select * from students into outfile '/tmp/test.csv' fields terminated by ',' optionally enclosed by '' escaped by '' lines terminated by '\r\n'; 执行后产生错误： ERROR 1 (HY000): Can't create/write to file '/home/trial/yqj/sql/test.csv' (E
select * from students into outfile '/tmp/test.csv' fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '\r\n';
执行后产生错误：
ERROR 1 (HY000): Can't create/write to file '/home/trial/yqj/sql/test.csv' (Errcode: 13)
经过网上搜索，原来是权限问题，/home/trial/yqj/sql/整个目录的权限必须都是可写的，后来改成
select * from students into outfile '/tmp/test.csv' fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '\r\n';就好了