全国省市县区三级数据集详解

全国省市县区三级联动数据集包含了各省、市、县、区的详细编码及名称信息，适用于数据库插入操作，如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', '区');