导出按生日排序的数据
mysql> select firstName,lastName,birthday,sex into outfile 'G:\\tb_test_out.txt'
from tb_test order by birthday;
mysql> select firstName,lastName,birthday,sex into outfile 'G:\\tb_test_out.txt'
from tb_test order by birthday;
Query OK, 10000000 rows affected (4 min 53.56 sec)
导入数据,重新生成id。
mysql> load data local infile 'G:\\tb_test_out.txt' into table tb_2 (firstName,l
astName,birthday,sex);
Query OK, 10000000 rows affected (2 min 23.08 sec)
Records: 10000000 Deleted: 0 Skipped: 0 Warnings: 0