MYSQL导出CSV的2种格式

来源:互联网 发布:农村淘宝合伙人盈利点 编辑:程序博客网 时间:2024/05/14 23:12
SELECT menuid,faceparameter INTO OUTFILE '/tmp/usermenu.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' FROM usermenu;


SELECT menuid,faceparameter INTO OUTFILE '/tmp/usermenu.csv' FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' FROM usermenu;

 

0 0
原创粉丝点击