MySQL导出CSV

MySQL导出CSV

按;号分隔
SELECT a,b,c FROM my_table INTO OUTFILE '/ca.csv' FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n';
按制表符分隔
SELECT keyword01,keyword02,url FROM csvbean2 INTO OUTFILE 'd:/csvbean2_test.csv' FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n';

按逗号分隔

SELECT keyword01,keyword02,url FROM csvbean2 INTO OUTFILE 'd:/csvbean2_test.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';