数据格式:

1,”1300000”,”山东”,”济南”,”中国联通”,”0531”,”250000”
2,”1300001”,”江苏”,”常州”,”中国联通”,”0519”,”213000”
3,”1300002”,”安徽”,”巢湖”,”中国联通”,”0565”,”238000”
4,”1300003”,”四川”,”宜宾”,”中国联通”,”0831”,”644000”
5,”1300004”,”四川”,”自贡”,”中国联通”,”0813”,”643000”
6,”1300005”,”陕西”,”西安”,”中国联通”,”029”,”710000”
7,”1300006”,”江苏”,”南京”,”中国联通”,”025”,”210000”
8,”1300007”,”陕西”,”西安”,”中国联通”,”029”,”710000”
9,”1300008”,”湖北”,”武汉”,”中国联通”,”027”,”430000”
10,”1300009”,”陕西”,”西安”,”中国联通”,”029”,”710000”
11,”1300010”,”北京”,”北京”,”中国联通”,”010”,”100000”
12,”1300011”,”北京”,”北京”,”中国联通”,”010”,”100000”
13,”1300012”,”天津”,”天津”,”中国联通”,”022”,”300000”
14,”1300013”,”天津”,”天津”,”中国联通”,”022”,”300000”
15,”1300014”,”天津”,”天津”,”中国联通”,”022”,”300000”
16,”1300015”,”山东”,”淄博”,”中国联通”,”0533”,”255000”
17,”1300016”,”山东”,”烟台”,”中国联通”,”0535”,”264000”
18,”1300017”,”山东”,”济南”,”中国联通”,”0531”,”250000”
19,”1300018”,”天津”,”天津”,”中国联通”,”022”,”300000”
20,”1300019”,”天津”,”天津”,”中国联通”,”022”,”300000”
21,”1300020”,”上海”,”上海”,”中国联通”,”021”,”200000”
22,”1300021”,”上海”,”上海”,”中国联通”,”021”,”200000”
23,”1300022”,”上海”,”上海”,”中国联通”,”021”,”200000”
24,”1300023”,”上海”,”上海”,”中国联通”,”021”,”200000”

数据要求:
txt文件需要存成UTF-8

数据库执行语句:

mysql> load data infile 'F:/Mobile/Mobile.txt' into table mybatis.phoneown
    -> fields terminated by','
    -> lines terminated by'\r\n'
    -> (id,num,province,city,name,areaCode,postCode);

错误总结:

Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
需要将secure-file-priv进行修改
​解决方式参考
MySQL ERROR 1300 (HY000): Invalid utf8 character string
将txt文本格式修改成UTF-8

Incorrect integer value: ” for column ‘id’ at row 1
​解决方式参考

数据库操作:
清空表主键归零：
​​​清空表主键归零​​

1.如果曾经的数据都不需要的话，可以直接清空所有数据，并将自增字段恢复从1开始计数：

truncate table table_name;