CODEWITHSUNDEEP
mysqlsqlcsv
DrXCheng
DrXCheng

Reputation: 4132

MySQL export CSV without quotes

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?

Upvotes: 2

Views: 2690

Answers (2)

Nanne
Nanne

Reputation: 64399

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?

Upvotes: 2

WWW
WWW

Reputation: 9860

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.

Upvotes: 2

Related Questions