全国省、市县、区三级联动数据 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', '海淀区');
- 1
- yjm2392013-06-03数据MS有点问题
- yhw_09232013-07-19跟我原有的一套很像,谢谢了。。
- meimao52112013-08-31资源很好 可惜不是我想要的那种 留着备用还是不错的额可以增加地理知识!
- 粉丝: 8
- 资源: 5
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助