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.

Answer 1

Try the following settings from SQLyog (12.1.2):

Answer 2

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