btbytes (owner)

Revisions

gist: 128095 Download_button fork
public
Description:
Export into a CSV file from MySQL
Public Clone URL: git://gist.github.com/128095.git
mysql2csv.sql
raw 
1
2
3
4
5
6
7
8
9

-- Export into a CSV file from MySQL
 
SELECT * from foologger 
INTO OUTFILE '/tmp/rrr.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n';
where dfd=2 and logtime >= '2009-06-08 05:00:00' and logtime <='2009-06-08 17:00:00' 
and qhr=1;