CODEWITHSUNDEEP
mysqlcsvdouble-quotessqlyog
MediaFormat
MediaFormat

Reputation: 377

export csv: enclose key with quotes in mysql

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.

Upvotes: 1

Views: 1126

Answers (2)

moven
moven

Reputation: 1

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

Upvotes: 0

wchiquito
wchiquito

Reputation: 16569

Try the following settings from SQLyog (12.1.2):

enter image description here

Upvotes: 2

Related Questions