--创建表 最新手机号段归属地数据库 --字段:前三位 号段 省份 城市 运营商类型 邮编 区号 行政区划编码 CREATE TABLE `phone``.`phone` ( `pref` VARCHAR(45) NULL, `phone` VARCHAR(45) NULL, `province` VARCHAR(45) NULL, `city` VARCHAR(45) NULL, `isp` VARCHAR(45) NULL, `post_code` VARCHAR(45) NULL, `city_code` VARCHAR(45) NULL, `area_code` VARCHAR(45) NULL ); #导入txt到mysql load data local infile 'c:/phone.txt' into table phone fields terminated by ' ' lines terminated by ' ' (pref, phone, province,city,isp,post_code,city_code,area_code); #导入csv到mysql load data local infile 'c:/phone.csv' into table phone fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by ' ' (pref, phone, province,city,isp,post_code,city_code,area_code);
mysql导入txt 或csv文件
此随笔或为自己所写、或为转载于网络。仅用于个人收集及备忘。