天气网省市区SQL

INSERT INTO city (id, pid, name, level) VALUES (‘200000’, ‘0’, ‘湖北’, ‘1’);
INSERT INTO city (id, pid, name, level) VALUES (‘200100’, ‘200000’, ‘武汉’, ‘2’);
INSERT INTO city (id, pid, name, code, level) VALUES (‘200101’, ‘200100’, ‘武汉’, ‘101200101’, ‘3’);
INSERT INTO city (id, pid, name, code, level) VALUES (‘200102’, ‘200100’, ‘蔡甸’, ‘101200102’, ‘3’);
INSERT INTO city (id, pid, name, code, level) VALUES (‘200103’, ‘200100’, ‘黄陂’, ‘101200103’, ‘3’);
INSERT INTO city (id, pid, name, code, level) VALUES (‘200104’, ‘200100’, ‘新洲’, ‘101200104’, ‘3’);
INSERT INTO city (id, pid, name, code, level) VALUES (‘200105’, ‘200100’, ‘江夏’, ‘101200105’, ‘3’);
INSERT INTO city (id, pid, name, code, level) VALUES (‘200106’, ‘200100’, ‘东西湖’, ‘101200106’, ‘3’);
INSERT INTO city (id, pid, name, code, level) VALUES (‘200107’, ‘200100’, ‘江岸’, ‘101200107’, ‘3’);
INSERT INTO city (id, pid, name, code, level) VALUES (‘200108’, ‘200100’, ‘江汉’, ‘101200108’, ‘3’);
INSERT INTO city (id, pid, name, code, level) VALUES (‘200109’, ‘200100’, ‘硚口’, ‘101200109’, ‘3’);
INSERT INTO city (id, pid, name, code, level) VALUES (‘200110’, ‘200100’, ‘汉阳’, ‘101200110’, ‘3’);
INSERT INTO city (id, pid, name, code, level) VALUES (‘200111’, ‘200100’, ‘武昌’, ‘101200111’, ‘3’);
INSERT INTO city (id, pid, name, code, level) VALUES (‘200112’, ‘200100’, ‘青山’, ‘101200112’, ‘3’);
INSERT INTO city (id, pid, name, code, level) VALUES (‘200113’, ‘200100’, ‘洪山’, ‘101200113’, ‘3’);
INSERT INTO city (id, pid, name, code, level) VALUES (‘200114’, ‘200100’, ‘汉南’, ‘101200114’, ‘3’);
INSERT INTO city (id, pid, name, level) VALUES (‘200200’, ‘200000’, ‘襄阳’, ‘2’);
INSERT INTO city (id, pid, name, code, level) VALUES (‘200201’, ‘200200’, ‘襄阳’, ‘101200201’, ‘3’);
INSERT INTO city (id, pid, name, code, level) VALUES (‘200202’, ‘200200’, ‘襄州’, ‘101200202’, ‘3’);
INSERT INTO city (id, pid, name, code, level) VALUES (‘200203’, ‘200200’, ‘保康’, ‘101200203’, ‘3’);

更多可下载
https://download.youkuaiyun.com/download/coder2600/89985743