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';就好了