-- 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;