MySQL导出CSV

liangjian103

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