MYSQL导出CSV的2种格式

SELECT menuid,faceparameter INTO OUTFILE '/tmp/usermenu.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' ' FROM usermenu;

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