export csv: enclose key with quotes in mysql

Question

I am exporting a mysql table to csv using SQLYog.

I can get all the fields enclosed with " ", except for the id column which is first, primary key and set to int.

I've tried removing the primary key and changing the id column to text, but to no avail.

Not sure if this is because it is the first column, id, primary key or what.

Also when exporting open the csv in a text editor. I was opening the file in excel and excel was formating the id as numeric and removing the double quotes around all the cells in that column!!! — MediaFormat
– MediaFormat, Commented Jun 10, 2015 at 15:29

wchiquito · Accepted Answer · 2015-06-09 17:24:40Z

2

Try the following settings from SQLyog (12.1.2):

enter image description here

answered Jun 9, 2015 at 17:24

wchiquito

16.6k2 gold badges37 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

moven · Accepted Answer · 2022-06-03 10:10:52Z

0

try another editor for example notepad to open your csv file. the quotes " " should be there.

answered Jun 3, 2022 at 10:10

moven

1

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

export csv: enclose key with quotes in mysql

2 Answers 2

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Related