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