以下代碼是sql文件代碼，粘貼復制到命令行執(zhí)行即可建立一個city表數(shù)據(jù)都保存到哪里！

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, '平?jīng)?#39;, 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, '畢節(jié)', 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, '新鄉(xiāng)', 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, '神農(nóng)架', 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, '鎮(zhèn)江', 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, '景德鎮(zhèn)', 18); INSERT INTO 2017year_all_citys_table_gogo VALUES(1806, 1800, '吉安', 18); INSERT INTO 2017year_all_citys_table_gogo VALUES(1807, 1800, '萍鄉(xiāng)', 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, '內(nèi)蒙古', 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, '中衛(wèi)', 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, '內(nèi)江', 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);

總結

以上是生活随笔為你收集整理的2017年最新的全国省市sql数据的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。