1.导出数据到文件命令
select * from student into outfile "d:/stduent.txt"
2.导入数据
load data local infile "a.txt" into table student
//把文件.txt文件导入到数据库的表中
load data local infile 'e:/source/test/2015-01-13.txt' into table tig_sessions;
/*+TDDL({'extra':{'SOCKET_TIMEOUT':'0'}})*/ 一直执行sql