MySQL export CSV without quotes

Question

I want to export the database to CSV file and read in MatLab. I use phpMyAdmin to export to CSV file, but each field is with quotes, so that MatLab cannot correctly read it. How can I export CSV file without quotes?

update

And how to use SQL command to export?

WWW · Accepted Answer · 2012-01-31 19:27:41Z

2

Depends on what version of phpMyAdmin you're using. In 3.4.9 (the latest release as of today), You'd select Export, Custom - display all possible options radio button, Format CSV, and just erase the Columns enclosed with: field.

answered Jan 31, 2012 at 19:27

WWW

9,8782 gold badges32 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

WWW Over a year ago

@xuc: phpMyAdmin (PMA) uses a script (found in your PMA's libraries/export/ path) that builds the export; there isn't a simple SQL command to do what you want.

Nanne · Accepted Answer · 2012-01-31 19:28:55Z

2

This is offtopic, but still: in PHPMyAdmin, if you use 'csv' as export, you can set the "Fields enclosed by" option to from " to nothing, right?

answered Jan 31, 2012 at 19:28

Nanne

64.4k16 gold badges122 silver badges166 bronze badges

Collectives™ on Stack Overflow

MySQL export CSV without quotes

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related