2013-07-31

MySql Select statement export to a file.



SELECT column_a, column_b, column_c FROM tb_abc INTO OUTFILE 'C:/folders/location/tb_abc.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';