MYSQL导出CSV的2种格式

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;