1.如何将数据表导入到mysql的表中，可以使用：load data infile ... into table ...
示例：
load data infile ‘e:\datainfo.txt‘ into table `table_1` fields terminated by ‘\t‘ lines terminated by‘\r\n‘
load data infile ‘e:\data2info.txt‘ into table `table_2` fields terminated by ‘\t‘ lines terminated by‘\r\n‘ (@abc,uid,name,@abc,age)
58297 lisi 17 58297 lisi 17 58297 lisi 17 58297 lisi 17 58297 lisi 17 58297 lisi 17
load data infile ‘e:\data3info.txt‘ into table `table_3` fields terminated by ‘\t‘ lines terminated by‘\r\n‘ (uid,name,age)
有的人，在导入数据时会遇到如下错误：
查询：load data local infile "e:\data1.txt" into table table(myid,myname,myaddr) fields terminated by ‘\t‘ lines terminat...
错误代码： 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘fields terminated by ‘\t‘ lines terminated by ‘\r\n‘‘ at line 1
大概可能是在写导入语句的时候：把指定字段的部分放到了表名后面，导致的。应该放到最后。
还有可能是mysql的版本不支持按照字段导入，那暂时无解。
参考：
原文：https://www.cnblogs.com/wangqiideal/p/11138669.html