2017年最新的全国省市sql数据

于 2016-07-14 12:21:26 发布
阅读量8.1k 收藏
点赞数 2
分类专栏： Mysql 文章标签： mysql sql 数据
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hj960511/article/details/51908190
版权

以下代码是sql文件代码，粘贴复制到命令行执行即可建立一个city表数据都保存到哪里！

mysql> CREATE TABLE  2017year_all_citys_table_gogo 
(
    id INT AUTO_INCREMENT PRIMARY KEY,
    parent_id INT NOT NULL DEFAULT 0,
    name VARCHAR(50) NOT NULL,
    sort INT NOT NULL DEFAULT 0
)ENGINE=INNODB DEFAULT CHARSET=UTF8;
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0100, 0, '安徽', 1);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0101, 0100, '合肥', 1);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0102, 0100, '安庆', 1);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0103, 0100, '毫州', 1);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0104, 0100, '蚌埠', 1);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0105, 0100, '滁州', 1);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0106, 0100, '巢湖', 1);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0107, 0100, '池州', 1);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0108, 0100, '阜阳', 1);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0109, 0100, '淮北', 1);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0110, 0100, '淮南', 1);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0111, 0100, '黄山站', 1);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0112, 0100, '六安', 1);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0113, 0100, '马鞍山', 1);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0114, 0100, '宿州', 1);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0115, 0100, '铜陵', 1);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0116, 0100, '芜湖', 1);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0117, 0100, '宣城', 1);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0200, 0, '澳门', 2);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0300, 0, '北京', 3);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0400, 0, '重庆', 4);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0500, 0, '福建', 5);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0501, 0500, '福州', 5);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0502, 0500, '龙岩', 5);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0503, 0500, '南平', 5);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0504, 0500, '宁德', 5);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0505, 0500, '莆田', 5);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0506, 0500, '泉州', 5);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0507, 0500, '三明', 5);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0508, 0500, '厦门', 5);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0509, 0500, '漳州', 5);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0600, 0, '甘肃', 6);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0601, 0600, '兰州', 6);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0602, 0600, '白银', 6);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0603, 0600, '定西', 6);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0604, 0600, '合作', 6);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0605, 0600, '金昌', 6);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0606, 0600, '酒泉', 6);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0607, 0600, '嘉峪关', 6);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0608, 0600, '临夏', 6);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0609, 0600, '平凉', 6);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0610, 0600, '庆阳', 6);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0611, 0600, '天水', 6);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0612, 0600, '武威', 6);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0613, 0600, '武都', 6);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0614, 0600, '张掖', 6);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0700, 0, '广东', 7);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0701, 0700, '广州', 7);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0702, 0700, '潮州', 7);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0703, 0700, '东莞', 7);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0704, 0700, '佛山', 7);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0705, 0700, '河源', 7);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0706, 0700, '惠州', 7);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0707, 0700, '江门', 7);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0708, 0700, '揭阳', 7);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0709, 0700, '梅州', 7);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0710, 0700, '茂名', 7);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0711, 0700, '清远', 7);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0712, 0700, '深圳', 7);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0713, 0700, '汕头', 7);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0714, 0700, '韶关', 7);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0715, 0700, '汕尾', 7);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0716, 0700, '阳江', 7);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0717, 0700, '云浮', 7);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0718, 0700, '珠海', 7);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0719, 0700, '中山', 7);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0720, 0700, '湛江', 7);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0721, 0700, '肇庆', 7);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0800, 0, '广西', 8);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0801, 0800, '南宁', 8);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0802, 0800, '北海', 8);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0803, 0800, '白色', 8);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0804, 0800, '崇左', 8);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0805, 0800, '防城港', 8);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0806, 0800, '桂林', 8);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0807, 0800, '贵港', 8);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0808, 0800, '贺州', 8);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0809, 0800, '河池', 8);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0810, 0800, '柳州', 8);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0811, 0800, '来宾', 8);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0812, 0800, '钦州', 8);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0813, 0800, '梧州', 8);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0814, 0800, '玉林', 8);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0900, 0, '贵州', 9);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0901, 0900, '贵阳', 9);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0902, 0900, '安顺', 9);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0903, 0900, '毕节', 9);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0904, 0900, '都匀', 9);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0905, 0900, '凯里', 9);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0906, 0900, '六盘水', 9);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0907, 0900, '晴隆', 9);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0908, 0900, '铜仁', 9);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0909, 0900, '兴义', 9);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(0910, 0900, '遵义', 9);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1000, 0, '海南', 10);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1001, 1000, '海口', 10);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1002, 1000, '白沙', 10);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1003, 1000, '保亭', 10);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1004, 1000, '澄迈', 10);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1005, 1000, '昌江', 10);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1006, 1000, '儋州', 10);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1007, 1000, '定安', 10);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1008, 1000, '东方', 10);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1009, 1000, '临高', 10);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1010, 1000, '陵水', 10);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1011, 1000, '乐东', 10);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1012, 1000, '南沙岛', 10);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1013, 1000, '琼海', 10);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1014, 1000, '琼中', 10);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1015, 1000, '三亚', 10);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1016, 1000, '屯昌', 10);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1017, 1000, '五指山', 10);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1018, 1000, '文昌', 10);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1019, 1000, '万宁', 10);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1020, 1000, '西沙', 10);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1100, 0, '河北', 11);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1101, 1100, '石家庄', 11);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1102, 1100, '保定', 11);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1103, 1100, '承德', 11);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1104, 1100, '沧州', 11);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1105, 1100, '衡水', 11);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1106, 1100, '邯郸', 11);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1107, 1100, '廊坊', 11);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1108, 1100, '秦皇岛', 11);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1109, 1100, '唐山', 11);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1110, 1100, '邢台', 11);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1111, 1100, '张家口', 11);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1200, 0, '河南', 12);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1201, 1200, '郑州', 12);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1202, 1200, '安阳', 12);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1203, 1200, '鹤壁', 12);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1204, 1200, '焦作', 12);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1205, 1200, '济源', 12);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1206, 1200, '开封', 12);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1207, 1200, '洛阳', 12);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1208, 1200, '漯河', 12);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1209, 1200, '南阳', 12);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1210, 1200, '濮阳', 12);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1211, 1200, '平顶山', 12);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1212, 1200, '三门峡', 12);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1213, 1200, '商丘', 12);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1214, 1200, '新乡', 12);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1215, 1200, '许昌', 12);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1216, 1200, '信阳', 12);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1217, 1200, '周口', 12);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1218, 1200, '驻马店', 12);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1300, 0, '黑龙江', 13);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1301, 1300, '哈尔滨', 13);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1302, 1300, '大庆', 13);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1303, 1300, '大兴安岭', 13);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1304, 1300, '鹤岗', 13);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1305, 1300, '黑河', 13);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1306, 1300, '佳木斯', 13);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1307, 1300, '鸡西', 13);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1308, 1300, '牡丹江', 13);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1309, 1300, '齐齐哈尔', 13);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1310, 1300, '七台河', 13);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1311, 1300, '双鸭山', 13);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1312, 1300, '绥化', 13);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1313, 1300, '伊春', 13);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1400, 0, '湖北', 14);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1401, 1400, '武汉', 14);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1402, 1400, '鄂州', 14);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1403, 1400, '恩施', 14);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1404, 1400, '黄石', 14);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1405, 1400, '黄冈', 14);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1406, 1400, '荆州', 14);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1407, 1400, '荆门', 14);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1408, 1400, '潜江', 14);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1409, 1400, '十堰', 14);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1410, 1400, '随州', 14);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1411, 1400, '神农架', 14);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1412, 1400, '天门', 14);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1413, 1400, '襄阳', 14);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1414, 1400, '孝感', 14);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1415, 1400, '咸宁', 14);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1416, 1400, '仙桃', 14);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1417, 1400, '宜昌', 14);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1500, 0, '湖南', 15);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1501, 1500, '长沙', 15);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1502, 1500, '常德', 15);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1503, 1500, '郴州', 15);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1504, 1500, '衡阳', 15);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1505, 1500, '怀化', 15);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1506, 1500, '吉首', 15);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1507, 1500, '娄底', 15);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1508, 1500, '黔阳', 15);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1509, 1500, '邵阳', 15);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1510, 1500, '湘潭', 15);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1511, 1500, '岳阳', 15);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1512, 1500, '益阳', 15);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1513, 1500, '永州', 15);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1514, 1500, '株洲', 15);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1515, 1500, '张家界', 15);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1600, 0, '吉林', 16);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1601, 1600, '长春', 16);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1602, 1600, '白山', 16);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1603, 1600, '白城', 16);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1604, 1600, '吉林', 16);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1605, 1600, '辽源', 16);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1606, 1600, '四平', 16);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1607, 1600, '松原', 16);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1608, 1600, '通化', 16);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1609, 1600, '延吉', 16);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1700, 0, '江苏', 17);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1701, 1700, '南京', 17);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1702, 1700, '常州', 17);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1703, 1700, '淮安', 17);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1704, 1700, '连云港', 17);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1705, 1700, '南通', 17);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1706, 1700, '苏州', 17);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1707, 1700, '宿迁', 17);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1708, 1700, '秦州', 17);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1709, 1700, '无锡', 17);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1710, 1700, '徐州', 17);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1711, 1700, '盐城', 17);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1712, 1700, '扬州', 17);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1713, 1700, '镇江', 17);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1800, 0, '江西', 18);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1801, 1800, '南昌', 18);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1802, 1800, '抚州', 18);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1803, 1800, '赣州', 18);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1804, 1800, '九江', 18);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1805, 1800, '景德镇', 18);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1806, 1800, '吉安', 18);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1807, 1800, '萍乡', 18);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1808, 1800, '上饶', 18);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1809, 1800, '新余', 18);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1810, 1800, '鹰潭', 18);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1811, 1800, '宜春', 18);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1900, 0, '辽宁', 19);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1901, 1900, '沈阳', 19);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1902, 1900, '鞍山', 19);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1903, 1900, '本溪', 19);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1904, 1900, '朝阳', 19);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1905, 1900, '大连', 19);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1906, 1900, '丹东', 19);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1907, 1900, '抚顺', 19);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1908, 1900, '阜新', 19);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1909, 1900, '葫芦岛', 19);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1910, 1900, '锦州', 19);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1911, 1900, '辽阳', 19);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1912, 1900, '盘锦', 19);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1913, 1900, '铁岭', 19);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(1914, 1900, '营口', 19);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2000, 0, '内蒙古', 20);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2001, 2000, '呼和浩特', 20);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2002, 2000, '阿拉善左旗', 20);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2003, 2000, '包头', 20);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2004, 2000, '赤峰', 20);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2005, 2000, '鄂尔多斯', 20);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2006, 2000, '呼伦贝尔', 20);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2007, 2000, '集宁', 20);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2008, 2000, '临河', 20);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2009, 2000, '通辽', 20);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2010, 2000, '乌兰浩特', 20);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2011, 2000, '乌海', 20);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2012, 2000, '锡林浩特', 20);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2100, 0, '宁夏', 21);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2101, 2100, '银川', 21);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2102, 2100, '固原', 21);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2103, 2100, '石嘴山', 21);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2104, 2100, '吴忠', 21);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2105, 2100, '中卫', 21);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2200, 0, '青海', 22);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2201, 2200, '西宁', 22);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2202, 2200, '果洛', 22);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2203, 2200, '海东', 22);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2204, 2200, '海南', 22);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2205, 2200, '海北', 22);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2206, 2200, '海西', 22);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2207, 2200, '黄南', 22);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2208, 2200, '玉树', 22);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2300, 0, '山东', 23);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2301, 2300, '济南', 23);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2302, 2300, '滨州', 23);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2303, 2300, '东营', 23);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2304, 2300, '德州', 23);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2305, 2300, '菏泽', 23);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2306, 2300, '济宁', 23);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2307, 2300, '莱芜', 23);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2308, 2300, '临沂', 23);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2309, 2300, '聊城', 23);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2310, 2300, '青岛', 23);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2311, 2300, '日照', 23);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2312, 2300, '泰安', 23);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2313, 2300, '潍坊', 23);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2314, 2300, '威海', 23);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2315, 2300, '烟台', 23);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2316, 2300, '淄博', 23);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2317, 2300, '枣庄', 23);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2400, 0, '山西', 24);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2401, 2400, '太原', 24);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2402, 2400, '长治', 24);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2403, 2400, '大同', 24);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2404, 2400, '晋城', 24);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2405, 2400, '晋中', 24);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2406, 2400, '临汾', 24);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2407, 2400, '吕梁', 24);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2408, 2400, '朔州', 24);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2409, 2400, '忻州', 24);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2410, 2400, '阳泉', 24);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2411, 2400, '运城', 24);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2500, 0, '陕西', 25);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2501, 2500, '西安', 25);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2502, 2500, '宝康', 25);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2503, 2500, '宝鸡', 25);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2504, 2500, '陈仓', 25);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2505, 2500, '汉中', 25);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2506, 2500, '商洛', 25);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2507, 2500, '铜川', 25);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2508, 2500, '渭南', 25);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2509, 2500, '咸阳', 25);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2510, 2500, '延安', 25);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2511, 2500, '榆林', 25);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2600, 0, '上海', 26);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2700, 0, '四川', 27);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2701, 2700, '成都', 27);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2702, 2700, '阿贝', 27);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2703, 2700, '巴中', 27);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2704, 2700, '德阳', 27);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2705, 2700, '达州', 27);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2706, 2700, '广元', 27);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2707, 2700, '广安', 27);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2708, 2700, '甘孜', 27);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2709, 2700, '泸州', 27);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2710, 2700, '乐山', 27);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2711, 2700, '凉山', 27);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2712, 2700, '绵阳', 27);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2713, 2700, '眉山', 27);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2714, 2700, '内江', 27);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2715, 2700, '南充', 27);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2716, 2700, '攀枝花', 27);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2717, 2700, '遂宁', 27);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2718, 2700, '宜宾', 27);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2719, 2700, '雅安', 27);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2720, 2700, '自贡', 27);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2721, 2700, '资阳', 27);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2800, 0, '天津', 28);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(2900, 0, '台湾', 29);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3000, 0, '西藏', 30);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3001, 3000, '拉萨', 30);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3002, 3000, '阿里', 30);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3003, 3000, '昌都', 30);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3004, 3000, '林芝', 30);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3005, 3000, '那曲', 30);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3006, 3000, '日喀则', 30);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3007, 3000, '山南', 30);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3100, 0, '香港', 31);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3200, 0, '新疆', 32);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3201, 3200, '乌鲁木齐', 32);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3202, 3200, '阿克苏', 32);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3203, 3200, '阿图什', 32);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3204, 3200, '阿勒泰', 32);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3205, 3200, '阿拉尔', 32);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3206, 3200, '博乐', 32);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3207, 3200, '昌吉', 32);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3208, 3200, '哈密', 32);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3209, 3200, '和田', 32);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3210, 3200, '克拉玛依', 32);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3211, 3200, '喀什', 32);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3212, 3200, '库尔勒', 32);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3213, 3200, '石河子', 32);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3214, 3200, '吐鲁番', 32);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3215, 3200, '塔城', 32);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3216, 3200, '伊宁', 32);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3300, 0, '云南', 33);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3301, 3300, '昆明', 33);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3302, 3300, '保山', 33);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3303, 3300, '楚雄', 33);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3304, 3300, '大理', 33);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3305, 3300, '德宏', 33);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3306, 3300, '红河', 33);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3307, 3300, '景洪', 33);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3308, 3300, '丽江', 33);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3309, 3300, '临沧', 33);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3310, 3300, '怒江', 33);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3311, 3300, '曲靖', 33);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3312, 3300, '思茅', 33);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3313, 3300, '文山', 33);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3314, 3300, '香格里拉', 33);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3315, 3300, '玉溪', 33);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3316, 3300, '昭通', 33);
 
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3400, 0, '浙江', 34);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3401, 3400, '杭州', 34);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3402, 3400, '湖州', 34);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3403, 3400, '嘉兴', 34);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3404, 3400, '金华', 34);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3405, 3400, '丽水', 34);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3406, 3400, '宁波', 34);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3407, 3400, '衢州', 34);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3408, 3400, '绍兴', 34);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3409, 3400, '台州', 34);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3410, 3400, '温州', 34);
INSERT INTO  2017year_all_citys_table_gogo  VALUES(3411, 3400, '舟山', 34);
任聪聪
关注
  • 2
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
2017全国省市县数据库
08-18
2017年3月全国省市区数据
mysql 外键
anzhang5248的博客
06-26 75
一、外键 constraint 名称 foreign key() references 表名() create table student( sid int auto_increment primary key, sname char(10), gender char(5), class_id int, constraint stu_key fo...
省市表SQL语句
weixin_30609331的博客
09-19 182
--创建省市(省表) create table 省市 ( proID int primary key, 省名 varchar(50) not null ) --中国34个省级行政单位 23个省 5个自治区 4个直辖市 2特别行政区 insert into 省市 values(1,'北京市') insert into 省市 values(2,...
全国省市区数据。sql
09-05
INSERT INTO `area` (`aid`,`areaID`,`area`,`cityID`) VALUES (1,110101,'东城区',110100), (2,110102,'西城区',110100), (3,110103,'崇文区',110100), (4,110104,'宣武区',110100), (5,110105,'朝阳区',110100), (6,110106,'丰台区',110100), (7,110107,'石景山区',110100), (8,110108,'海淀区',110100), (9,110109,'门头沟区',110100), (10,110111,'房山区',110100), (11,110112,'通州区',110100), (12,110113,'顺义区',110100), (13,110114,'昌平区',110100), (14,110115,'大兴区',110100), (15,110116,'怀柔区',110100), (16,110117,'平谷区',110100), (17,110228,'密云县',110200), (18,110229,'延庆县',110200), (19,120101,'和平区',120100), (20,120102,'河东区',120100), (21,120103,'河西区',120100), (22,120104,'南开区',120100), (23,120105,'河北区',120100), (24,120106,'红桥区',120100), (25,120107,'塘沽区',120100), (26,120108,'汉沽区',120100), (27,120109,'大港区',120100), (28,120110,'东丽区',120100), (29,120111,'西青区',120100), (30,120112,'津南区',120100);
全国城市数据库sql
01-10
最新的全国省市区数据 已分配好一二三四级编码 建表和插入数据sql 文件
2017年省市区sql数据
10-18
2017年的省市区sql数据，上传方便开发使用！经供参考！
2017年最新省市区数据
07-25
2017年最新省市区数据,里面有表格与sql文件,解压即可
2017年中国省市区及经纬度SQL2012脚本
12-17
2017年中国省市区及经纬度SQL2012脚本，解压直接打开数据即可执行脚本生成所需的表与数据
2017最新省市区基础数据库sql
10-04
/* 根据国家统计局最新县及县以上行政区划代码（截止2016年7月31日）制作[发布时间：2017-03-10 10:33] */ /* http://www.stats.gov.cn/tjsj/tjbz/xzqhdm/201703/t20170310_1471429.html */ ...
全国城市SQL数据表
09-30
很不错的数据表！希望能够帮到你，十分欢迎各位朋友来下载！
2017年全国省市区数据JSON
09-15
2017年全国省市区数据JSON 一般会用数据库，这样修改维护起来太麻烦，直接一项目中使用JSON数据，分成三级，包含了省、市、区名称及代码
全国城市列表mysql数据库
09-07
全国家标准省市区数据表，操作简单方便，不占太多资源
全国省市区数据SQL - 省市区-自联表-2018-最新-省市区最新编码-全国省市区mysql数据库(单表)-省市区数据库
02-03
全国省市区数据SQL,省市区,自联表,2018最新省市区,最新编码,全国省市区mysql数据库(单表),省市区数据库
全国最新的省市区数据json文档
01-23
全国最新的省市区数据json文档，支持json格式的开发工具均可使用。自己在项目中也使用的该数据，用于分享给需要的朋友
2017年最新版-全国五级行政区域数据SQL
12-11
2017年最新版-全国五级行政区域数据SQL； mysql数据库可直接导入使用，数据截止日期为20171031，与国家统计局保持一致，包含 省 市 区县 街镇 乡村，以及 邮编、电话区号、经纬度坐标等。
中国城市sql表
05-08
国内城市的资源表，MYSQL数据库，可直接导入，表名需要修改的话编辑器修改下就可以了
抓取国家统计局2017年的省市区街道数据
08-14
我们项目也需要省市区街道级联关系，上网找了一些，感觉都不全，于是，自己用python写了一个脚本从国家统计局抓取的数据，2018年的数据应该还没有更新出来，所以只抓取的2017年的数据， 数据地址来源于：http://www.stats.gov.cn/tjsj/tjbz/tjyqhdmhcxhfdm/2017/index.html
全国省市县城市数据大全（执行sql语句并带数据库表结构）
12-02
自己收藏多年的全国省市县数据sql，并带有数据库表模型，直接按模型创建数据库表，sql一执行就可以拥有全国到县级别的数据源了。
最新全国大学sql数据
最新发布
01-10
最新全国大学的SQL数据包括大学名称、地理位置、成立时间、学校类型、学科领域、学校层次、学生人数等信息。这些数据可以用于进行大学排名、教育政策制定、学生选校等方面的分析和研究。 首先，大学名称是数据中最...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

任聪聪

创作不易，你的打赏是我的动力！

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值