double quotes while importing csv

[expired user #7044]'s profile image [expired user #7044] posted 11 years ago in General Permalink
Hi,

I am trying to import a csv file with seven columns that contain integers and strings. After I import it through HeidiSQL, I notice that two of the columns have double quotes in them.

Can someone please tell me how can I get rid of this while importing?

Thanks
ansgar's profile image ansgar posted 11 years ago Permalink
You have probably not set the "Encloser" in the import dialog? Try setting to double quote (") and import again.

Please login to leave a reply, or register at first.