参考: http://blog.csdn.net/lonesomer/archive/2006/05/04/708193.aspx
实例:
use mydb;
select * from person into outfile "d:\data.txt";
use otherdb;
load data local infile "d:\data.txt" into table person;
mysql> source script.sql
参考: http://blog.csdn.net/lonesomer/archive/2006/05/04/708193.aspx
实例:
use mydb;
select * from person into outfile "d:\data.txt";
use otherdb;
load data local infile "d:\data.txt" into table person;
mysql> source script.sql