数据格式:
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;
