CODEWITHSUNDEEP
mysqlexcelexport-to-excel
JoJo
JoJo

Reputation: 4933

Export resultset from MySql as Tab delimited file. Strings with commas in them are getting Quotes around the string, why?

I am doing an export from a MySQL result-set and what I am finding in the .txt file when I open it in Notepad++ is there are fields that looked like this Top Side Panel w/ Bracket, Left now look like this "Top Side Panel w/ Bracket, Left" with extra quotes.

This is only happening on the fields with a comma in them. So it does not occur on a record with this in the same field for example: Rear Baffle

How do you do a correct Tab Delimited export from MySQL Query Browser 1.2.17 where we do not get added data!?

Thank you.

Upvotes: 1

Views: 4189

Answers (2)

Mike Brant
Mike Brant

Reputation: 71422

You can use MySQL's SELECT INTO OUTFILE syntax to give you a native MySQL way to generate CSV or TSV files. This command gives you full control over how you delineate and escape your fields. See the link below for documentation.

http://dev.mysql.com/doc/refman/5.5/en/select-into.html

Upvotes: 1

SaidbakR
SaidbakR

Reputation: 13544

I recommend to use phpMyAdmin. It offers an export tool that exports csv for MS Excel.

Upvotes: 1

Related Questions