把mysql中的表数据导到excel中
命令如下:
select * from aaa into outfile ‘d:\\aa.csv’ fields terminated by ‘,’ enclosed by ‘"’;
|
这是fengyqf的博客
把mysql中的表数据导到excel中
命令如下:
select * from aaa into outfile ‘d:\\aa.csv’ fields terminated by ‘,’ enclosed by ‘"’;
|