How to export table data in MySql Workbench to csv?
Mysql WorkbenchMysql Workbench Problem Overview
I am wondering how do I export table data into a csv? I read that I need to use mysql workbench command line but I can not figure out how to launch the cmd line(don't know what the command is).
Running on Windows 7 64bit.
Mysql Workbench Solutions
Solution 1 - Mysql Workbench
You can select the rows from the table you want to export in the MySQL Workbench SQL Editor. You will find an Export button in the resultset that will allow you to export the records to a CSV file, as shown in the following image:
Please also keep in mind that by default MySQL Workbench limits the size of the resultset to 1000 records. You can easily change that in the Preferences dialog:
Hope this helps.
Solution 2 - Mysql Workbench
U can use mysql dump or query to export data to csv file
SELECT *
INTO OUTFILE '/tmp/products.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
FROM products
Solution 3 - Mysql Workbench
MySQL Workbench 6.3.6
Export the SELECT result
-
After you run a
SELECT: Query > Export Results...
Export table data
-
In the Navigator, right click on the table > Table Data Export Wizard
-
All columns and rows are included by default, so click on Next.
-
Select File Path, type, Field Separator (by default it is
;, not,!!!) and click on Next.
-
Click Next > Next > Finish and the file is created in the specified location