Date: 01/27/08 (MySQL Communtiy)    Keywords: mysql, sql

sort of a sequel to my previous post.

I'm importing a .csv file into mysql table. All entries in the original flie are in the following format: "price", separated by commas. After they are imported, the number of quotation marks doubles, i.e. in my table every entry looks like ""price"", which sucks! I need to export this into Matlab or other interfaces, or simple Excel spreadsheet, and what I get is "price" rather than price!

Could anyone help here?

cheers,

j_a

Source: http://community.livejournal.com/mysql/124524.html