INSERT INTO hat_province VALUES (1,'110000','北京市');
INSERT INTO hat_province VALUES (2,'120000','天津市');
INSERT INTO hat_province VALUES (3,'130000','河北省');
INSERT INTO hat_province VALUES (4,'140000','山西省');
INSERT INTO hat_province VALUES (5,'150000','内蒙古自治区');
INSERT INTO hat_province VALUES (6,'210000','辽宁省');
INSERT INTO hat_province VALUES (7,'220000','吉林省');
INSERT INTO hat_province VALUES (8,'230000','黑龙江省');
INSERT INTO hat_province VALUES (9,'310000','上海市');
INSERT INTO hat_province VALUES (10,'320000','江苏省');
INSERT INTO hat_province VALUES (11,'330000','浙江省');
INSERT INTO hat_province VALUES (12,'340000','安徽省');
INSERT INTO hat_province VALUES (13,'350000','福建省');
INSERT INTO hat_province VALUES (14,'360000','江西省');
INSERT INTO hat_province VALUES (15,'370000','山东省');
INSERT INTO hat_province VALUES (16,'410000','河南省');
INSERT INTO hat_province VALUES (17,'420000','湖北省');
INSERT INTO hat_province VALUES (18,'430000','湖南省');
........
INSERT INTO hat_city VALUES (1,'110100','市辖区','110000');
INSERT INTO hat_city VALUES (2,'110200','县','110000');
INSERT INTO hat_city VALUES (3,'120100','市辖区','120000');
INSERT INTO hat_city VALUES (4,'120200','县','120000');
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_city VALUES (12,'130800','承德市','130000');
INSERT INTO hat_city VALUES (13,'130900','沧州市','130000');
INSERT INTO hat_city VALUES (14,'131000','廊坊市','130000');
INSERT INTO hat_city VALUES (15,'131100','衡水市','130000');