文件名称：省市区三级数据库表
文件大小：221KB
文件格式：SQL
更新时间：2019-07-23 04:55:17
省市区数据库
省市区三级数据库表 CREATE TABLE hat_city ( id int NOT NULL , cityID varchar(6) default NULL, city varchar(50) default NULL, father varchar(6) default NULL, PRIMARY KEY (id) ) CREATE TABLE hat_province( ....) CREATE TABLE hat_zone ( ....) INSERT INTO hat_province VALUES (3,'130000','河北省'); INSERT INTO hat_province VALUES (4,'140000','山西省'); INSERT INTO hat_province VALUES (5,'0000','内蒙古自治区'); INSERT INTO hat_province VALUES (6,'210000','辽宁省'); INSERT INTO hat_province VALUES (7,'220000','吉林省'); INSERT INTO hat_province VALUES (8,'230000','黑龙江省'); ....... INSERT INTO hat_city VALUES (5,'130100','石家庄市','130000'); INSERT INTO hat_city VALUES (6,'130200','唐山市','130000'); INSERT INTO hat_city VALUES (7,'130300','秦皇岛市','130000'); INSERT INTO hat_city VALUES (8,'130400','邯郸市','130000'); INSERT INTO hat_city VALUES (9,'130500','邢台市','130000'); INSERT INTO hat_city VALUES (10,'130600','保定市','130000'); INSERT INTO hat_city VALUES (11,'130700','张家口市','130000'); ....... INSERT INTO hat_zone VALUES (1,'110101','东城区','110100'); INSERT INTO hat_zone VALUES (2,'110102','西城区','110100'); INSERT INTO hat_zone VALUES (3,'110103','崇文区','110100'); INSERT INTO hat_zone VALUES (4,'110104','宣武区','110100'); INSERT INTO hat_zone VALUES (5,'110105','朝阳区','110100'); INSERT INTO hat_zone VALUES (6,'110106','丰台区','110100'); INSERT INTO hat_zone VALUES (7,'110107','石景山区','110100'); INSERT INTO hat_zone VALUES (8,'110108','海淀区','110100'); INSERT INTO hat_zone VALUES (9,'110109','门头沟区','110100'); INSERT INTO hat_zone VALUES (10,'110111','房山区','110100');