CREATE TABLE `areas` (

`id`  VARCHAR(45) NULL,

`parent_id` VARCHAR(45) NULL,

`name` VARCHAR(45) NULL,

`merger_name` VARCHAR(200) NULL,

`short_name` VARCHAR(45) NULL,

`merger_short_name` VARCHAR(200) NULL,

`level_type` VARCHAR(45) NULL,

`city_code` VARCHAR(45) NULL,

`zip_code` VARCHAR(45) NULL,

`pinyin` VARCHAR(45) NULL,

`jianpin` VARCHAR(45) NULL,

`first_char` VARCHAR(45) NULL,

`lng` VARCHAR(45) NULL,

`lat` VARCHAR(45) NULL,

`remark` VARCHAR(45) NULL

);

LOAD DATA LOCAL INFILE 'c:/areas.txt'

INTO TABLE areas

FIELDS TERMINATED BY '\t'

LINES TERMINATED BY '\n'

(id,parent_id,name,merger_name,short_name,merger_short_name,level_type,city_code,zip_code,pinyin,jianpin,first_char,lng,Lat,remark);