mysql导出数据库表到xls

使用以下sql：

select * from t_series into outfile '/tmp/series.xls';

时报错：
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

这时查看文件读写权限：

SHOW VARIABLES LIKE "secure_file_priv";

显示

然后将“/etc/my.cnf”中添加一行

为空代表不限制导入导出
下面就可以导出了

另外：加上列名导出cvs文件，然后将CVS转化为xls即可

select * into outfile '/tmp/series.csv' fields terminated by ',' lines terminated by '\n' from (select
'电视剧名',
'F_LicensingWindowStart',
'F_LicensingWindowEnd',
'F_VolumnCount',
'F_Description',
'F_WriterDisplay',
'F_ReleaseYear',
'F_PhonePosterUrl',
'F_Param1',
'F_Param2'
union select
F_Name,
F_LicensingWindowStart,
F_LicensingWindowEnd,
F_VolumnCount,
F_Description,
F_WriterDisplay,
F_ReleaseYear,
F_PhonePosterUrl,
F_Param1,
F_Param2
from t_series

) b;