Monthly Archives: September 2008

Full table select: SELECT * INTO OUTFILE ‘/tmp/file.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n’ FROM `table`; Variations(for instance select from derived table): SELECT tbl.* INTO OUTFILE ‘/tmp/file.csv’ FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY … Continue reading →