Create CSV from MySQL

Submitted by:David Villa

Date added:19 May, 2012

Category:MySQL

Example code to create CSV from MySQL

Tags: mysql to csv

Code Snippet:

SELECT a,b,c FROM my_table INTO OUTFILE '/ca.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
 
 

Comments