MySql直接命令行执行select和load导入导出数据

导出:

select * into outfile 'd:/ad.txt' from a limit 100;

 

 

 

导入：

load data local infile 'd:/ad.txt' into table a lines terminated by '\n';