How can I export csv from MySQL automatically?

Asked By Powel Edward 0 points N/A Posted on - 12/10/2012

Hi,

I need your help. I'm facing problem to export csv from mysql automatically? How can I do it easily? What kind of software is better? Please inform me in details.

Thanks.

• Status: Open
• Question Views: 892
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by Mclean Buono

Go To Solution

Answered By Maverick Aabel 0 points N/A #150232

How can I export csv from MySQL automatically?

Hi Edward,

I will provide you a simple solution to this problem.

MySQL has more options for exporting data, one of them being “SELECT INTO OUTFILE” query.

This will export your results returned by your sql query into the CSV file specified by you.

Using this code:

SELECT * INTO OUTFILE '/tmp/your_file.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY 'n' FROM table_that_you_want

Please make sure that MySQL has write permission on “/tmp/” folder.

Happy coding.

Aabel

About Maverick Aabel

Questions
3

Answers
54

Best Answers
26

• Vote Up 0 Vote Down

• Posted on - 12/11/2012
• Question Category: MySQL Server

Best Answer

Best Answer

Answered By Mclean Buono 10 points N/A #150233

How can I export csv from MySQL automatically?

Hi Edward,

It is even possible to export all tables from a database in a CSV file, you can use the mysqldump utility to do that.

This command will help

mysqldump – u [username] – p – t – T[/path/to/directory] [database] — fields – enclosed-by =" –fields-terminated – by =,

Replace [username] with the MySQL username

[/path/to/directory] with the path to the directory where data will exported to.

[database] the name of the database from which all tables will be exported.

• T indicates create table statements will not be exported.
• T will dump the data in tab delimited format,
• Fields-terminated-by will change the delimiter from tab to comma

Please note due to presence of flag — fields-enclosed-by = " all column data will be enclosed with double quotes.

Hope this helps you.

About Mclean Buono

Questions
6

Answers
99

Best Answers
33

• Vote Up 0 Vote Down

• Posted on - 06/25/2013
• Question Category: MySQL Server