mysql关联表导出_MySQL表的导出

select * from actor into outfile '/data/actor.text' fields terminated by "," enclosed by '"';

第一列是数值型，两边不加引号，则改为：

select * from actor into outfile '/data/actor1.text' fields terminated by "," optionally enclosed by '"';

导出不加引号&#x