文件名称：全国省市县区三级联动数据
文件大小：35KB
文件格式：ZIP
更新时间：2016-01-27 09:58:41
全国省市区 SQL 地区三级
全国省、市县、区三级联动数据 INSERT INTO `demo_province` (`CODE`, `PROVINCENAME`) VALUES ('110000', '北京市'); INSERT INTO `demo_province` (`CODE`, `PROVINCENAME`) VALUES ('120000', '天津市'); INSERT INTO `demo_province` (`CODE`, `PROVINCENAME`) VALUES ('130000', '河北省'); INSERT INTO `demo_province` (`CODE`, `PROVINCENAME`) VALUES ('140000', '山西省'); INSERT INTO `demo_province` (`CODE`, `PROVINCENAME`) VALUES ('150000', '内蒙古自治区'); INSERT INTO `demo_province` (`CODE`, `PROVINCENAME`) VALUES ('210000', '辽宁省'); INSERT INTO `demo_province` (`CODE`, `PROVINCENAME`) VALUES ('220000', '吉林省'); ------------------------------------------------------ INSERT INTO `demo_city` (`CODE`, `PROVINCECODE`, `CITYNAME`) VALUES ('110100', '110000', '区'); INSERT INTO `demo_city` (`CODE`, `PROVINCECODE`, `CITYNAME`) VALUES ('110200', '110000', '县'); INSERT INTO `demo_city` (`CODE`, `PROVINCECODE`, `CITYNAME`) VALUES ('120100', '120000', '区'); INSERT INTO `demo_city` (`CODE`, `PROVINCECODE`, `CITYNAME`) VALUES ('120200', '120000', '县'); INSERT INTO `demo_city` (`CODE`, `PROVINCECODE`, `CITYNAME`) VALUES ('130100', '130000', '石家庄市'); INSERT INTO `demo_city` (`CODE`, `PROVINCECODE`, `CITYNAME`) VALUES ('130200', '130000', '唐山市'); INSERT INTO `demo_city` (`CODE`, `PROVINCECODE`, `CITYNAME`) VALUES ('130300', '130000', '秦皇岛市'); INSERT INTO `demo_city` (`CODE`, `PROVINCECODE`, `CITYNAME`) VALUES ('130400', '130000', '邯郸市'); ------------------------------------------------ INSERT INTO `demo_county` (`CODE`, `CITYCODE`, `COUNTYNAME`) VALUES ('110103', '110100', '崇文区'); INSERT INTO `demo_county` (`CODE`, `CITYCODE`, `COUNTYNAME`) VALUES ('110104', '110100', '宣武区'); INSERT INTO `demo_county` (`CODE`, `CITYCODE`, `COUNTYNAME`) VALUES ('110105', '110100', '朝阳区'); INSERT INTO `demo_county` (`CODE`, `CITYCODE`, `COUNTYNAME`) VALUES ('110106', '110100', '丰台区'); INSERT INTO `demo_county` (`CODE`, `CITYCODE`, `COUNTYNAME`) VALUES ('110107', '110100', '石景山区'); INSERT INTO `demo_county` (`CODE`, `CITYCODE`, `COUNTYNAME`) VALUES ('110108', '110100', '海淀区');
【文件预览】：
demo_province.sql
demo_county.sql
demo_city.sql