博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
关于城市的sql语句
阅读量:5078 次
发布时间:2019-06-12

本文共 23683 字,大约阅读时间需要 78 分钟。

INSERT INTO base_city VALUES ('110001', '110000', '北京市', 'BJ', '1');

INSERT INTO base_city VALUES ('120001', '120000', '天津市', 'TJ', '1');
INSERT INTO base_city VALUES ('130100', '130000', '石家庄市', 'SJ', '2');
INSERT INTO base_city VALUES ('130200', '130000', '唐山市', 'TS', '3');
INSERT INTO base_city VALUES ('130300', '130000', '秦皇岛市', 'QH', '3');
INSERT INTO base_city VALUES ('130400', '130000', '邯郸市', 'HD', '3');
INSERT INTO base_city VALUES ('130500', '130000', '邢台市', 'XT', '4');
INSERT INTO base_city VALUES ('130600', '130000', '保定市', 'BD', '3');
INSERT INTO base_city VALUES ('130700', '130000', '张家口市', 'ZJ', '4');
INSERT INTO base_city VALUES ('130800', '130000', '承德市', 'CD', '4');
INSERT INTO base_city VALUES ('130900', '130000', '沧州市', 'CZ', '3');
INSERT INTO base_city VALUES ('131000', '130000', '廊坊市', 'LF', '3');
INSERT INTO base_city VALUES ('131100', '130000', '衡水市', 'HS', '5');
INSERT INTO base_city VALUES ('140100', '140000', '太原市', 'TY', '2');
INSERT INTO base_city VALUES ('140200', '140000', '大同市', 'DT', '4');
INSERT INTO base_city VALUES ('140300', '140000', '阳泉市', 'YQ', '5');
INSERT INTO base_city VALUES ('140400', '140000', '长治市', 'CZ', '5');
INSERT INTO base_city VALUES ('140500', '140000', '晋城市', 'JC', '5');
INSERT INTO base_city VALUES ('140600', '140000', '朔州市', 'SZ', '5');
INSERT INTO base_city VALUES ('140700', '140000', '晋中市', 'JZ', '4');
INSERT INTO base_city VALUES ('140800', '140000', '运城市', 'YC', '4');
INSERT INTO base_city VALUES ('140900', '140000', '忻州市', 'XZ', '5');
INSERT INTO base_city VALUES ('141000', '140000', '临汾市', 'LF', '4');
INSERT INTO base_city VALUES ('141100', '140000', '吕梁市', 'LL', '5');
INSERT INTO base_city VALUES ('150100', '150000', '呼和浩特市', 'HH', '3');
INSERT INTO base_city VALUES ('150200', '150000', '包头市', 'PT', '3');
INSERT INTO base_city VALUES ('150300', '150000', '乌海市', 'WH', '5');
INSERT INTO base_city VALUES ('150400', '150000', '赤峰市', 'CF', '4');
INSERT INTO base_city VALUES ('150500', '150000', '通辽市', 'TL', '4');
INSERT INTO base_city VALUES ('150600', '150000', '鄂尔多斯市', 'EE', '4');
INSERT INTO base_city VALUES ('150700', '150000', '呼伦贝尔市', 'HL', '4');
INSERT INTO base_city VALUES ('150800', '150000', '巴彦淖尔市', 'BY', '5');
INSERT INTO base_city VALUES ('150900', '150000', '乌兰察布市', 'WL', '5');
INSERT INTO base_city VALUES ('152200', '150000', '兴安盟', 'XA', '5');
INSERT INTO base_city VALUES ('152500', '150000', '锡林郭勒盟', 'XL', '5');
INSERT INTO base_city VALUES ('152900', '150000', '阿拉善盟', 'AL', '5');
INSERT INTO base_city VALUES ('210100', '210000', '沈阳市', 'SY', '2');
INSERT INTO base_city VALUES ('210200', '210000', '大连市', 'DL', '2');
INSERT INTO base_city VALUES ('210300', '210000', '鞍山市', 'AS', '3');
INSERT INTO base_city VALUES ('210400', '210000', '抚顺市', 'WS', '3');
INSERT INTO base_city VALUES ('210500', '210000', '本溪市', 'BX', '4');
INSERT INTO base_city VALUES ('210600', '210000', '丹东市', 'DD', '3');
INSERT INTO base_city VALUES ('210700', '210000', '锦州市', 'JZ', '4');
INSERT INTO base_city VALUES ('210800', '210000', '营口市', 'YK', '3');
INSERT INTO base_city VALUES ('210900', '210000', '阜新市', 'FX', '4');
INSERT INTO base_city VALUES ('211000', '210000', '辽阳市', 'LY', '4');
INSERT INTO base_city VALUES ('211100', '210000', '盘锦市', 'PJ', '3');
INSERT INTO base_city VALUES ('211200', '210000', '铁岭市', 'TL', '4');
INSERT INTO base_city VALUES ('211300', '210000', '朝阳市', 'CY', '5');
INSERT INTO base_city VALUES ('211400', '210000', '葫芦岛市', 'HL', '4');
INSERT INTO base_city VALUES ('220100', '220000', '长春市', 'CC', '2');
INSERT INTO base_city VALUES ('220200', '220000', '吉林市', 'JL', '3');
INSERT INTO base_city VALUES ('220300', '220000', '四平市', 'SP', '4');
INSERT INTO base_city VALUES ('220400', '220000', '辽源市', 'LY', '5');
INSERT INTO base_city VALUES ('220500', '220000', '通化市', 'TH', '4');
INSERT INTO base_city VALUES ('220600', '220000', '白山市', 'BS', '5');
INSERT INTO base_city VALUES ('220700', '220000', '松原市', 'SY', '5');
INSERT INTO base_city VALUES ('220800', '220000', '白城市', 'BC', '5');
INSERT INTO base_city VALUES ('222400', '220000', '延边朝鲜族自治州', 'YB', '3');
INSERT INTO base_city VALUES ('230100', '230000', '哈尔滨市', 'HE', '2');
INSERT INTO base_city VALUES ('230200', '230000', '齐齐哈尔市', 'QQ', '3');
INSERT INTO base_city VALUES ('230300', '230000', '鸡西市', 'JX', '5');
INSERT INTO base_city VALUES ('230400', '230000', '鹤岗市', 'HG', '5');
INSERT INTO base_city VALUES ('230500', '230000', '双鸭山市', 'SY', '5');
INSERT INTO base_city VALUES ('230600', '230000', '大庆市', 'DQ', '3');
INSERT INTO base_city VALUES ('230700', '230000', '伊春市', 'YC', '5');
INSERT INTO base_city VALUES ('230800', '230000', '佳木斯市', 'JM', '4');
INSERT INTO base_city VALUES ('230900', '230000', '七台河市', 'QT', '5');
INSERT INTO base_city VALUES ('231000', '230000', '牡丹江市', 'MD', '4');
INSERT INTO base_city VALUES ('231100', '230000', '黑河市', 'HH', '5');
INSERT INTO base_city VALUES ('231200', '230000', '绥化市', 'SH', '5');
INSERT INTO base_city VALUES ('232700', '230000', '大兴安岭地区', 'DX', '5');
INSERT INTO base_city VALUES ('310001', '310000', '上海市', 'SH', '1');
INSERT INTO base_city VALUES ('320100', '320000', '南京市', 'NJ', '2');
INSERT INTO base_city VALUES ('320200', '320000', '无锡市', 'WX', '2');
INSERT INTO base_city VALUES ('320300', '320000', '徐州市', 'XZ', '3');
INSERT INTO base_city VALUES ('320400', '320000', '常州市', 'CZ', '3');
INSERT INTO base_city VALUES ('320500', '320000', '苏州市', 'SZ', '2');
INSERT INTO base_city VALUES ('320600', '320000', '南通市', 'NT', '3');
INSERT INTO base_city VALUES ('320700', '320000', '连云港市', 'LY', '3');
INSERT INTO base_city VALUES ('320800', '320000', '淮安市', 'HA', '3');
INSERT INTO base_city VALUES ('320900', '320000', '盐城市', 'YC', '3');
INSERT INTO base_city VALUES ('321000', '320000', '扬州市', 'YZ', '3');
INSERT INTO base_city VALUES ('321100', '320000', '镇江市', 'ZJ', '3');
INSERT INTO base_city VALUES ('321200', '320000', '泰州市', 'TZ', '3');
INSERT INTO base_city VALUES ('321300', '320000', '宿迁市', 'SQ', '4');
INSERT INTO base_city VALUES ('330100', '330000', '杭州市', 'HZ', '2');
INSERT INTO base_city VALUES ('330200', '330000', '宁波市', 'NB', '2');
INSERT INTO base_city VALUES ('330300', '330000', '温州市', 'WZ', '2');
INSERT INTO base_city VALUES ('330400', '330000', '嘉兴市', 'JX', '3');
INSERT INTO base_city VALUES ('330500', '330000', '湖州市', 'HZ', '3');
INSERT INTO base_city VALUES ('330600', '330000', '绍兴市', 'SX', '3');
INSERT INTO base_city VALUES ('330700', '330000', '金华市', 'JH', '3');
INSERT INTO base_city VALUES ('330800', '330000', '衢州市', 'CZ', '3');
INSERT INTO base_city VALUES ('330900', '330000', '舟山市', 'ZS', '3');
INSERT INTO base_city VALUES ('331000', '330000', '台州市', 'TZ', '3');
INSERT INTO base_city VALUES ('331100', '330000', '丽水市', 'LS', '3');
INSERT INTO base_city VALUES ('340100', '340000', '合肥市', 'HF', '2');
INSERT INTO base_city VALUES ('340200', '340000', '芜湖市', 'WH', '3');
INSERT INTO base_city VALUES ('340300', '340000', '蚌埠市', 'BB', '3');
INSERT INTO base_city VALUES ('340400', '340000', '淮南市', 'HN', '4');
INSERT INTO base_city VALUES ('340500', '340000', '马鞍山市', 'MA', '3');
INSERT INTO base_city VALUES ('340600', '340000', '淮北市', 'HB', '5');
INSERT INTO base_city VALUES ('340700', '340000', '铜陵市', 'TN', '5');
INSERT INTO base_city VALUES ('340800', '340000', '安庆市', 'AQ', '4');
INSERT INTO base_city VALUES ('341000', '340000', '黄山市', 'HS', '4');
INSERT INTO base_city VALUES ('341100', '340000', '滁州市', 'CZ', '4');
INSERT INTO base_city VALUES ('341200', '340000', '阜阳市', 'FY', '4');
INSERT INTO base_city VALUES ('341300', '340000', '宿州市', 'SZ', '4');
INSERT INTO base_city VALUES ('341400', '340000', '巢湖市', 'CH', '5');
INSERT INTO base_city VALUES ('341500', '340000', '六安市', 'LA', '4');
INSERT INTO base_city VALUES ('341600', '340000', '亳州市', 'HZ', '5');
INSERT INTO base_city VALUES ('341700', '340000', '池州市', 'CZ', '5');
INSERT INTO base_city VALUES ('341800', '340000', '宣城市', 'XC', '4');
INSERT INTO base_city VALUES ('350100', '350000', '福州市', 'FZ', '2');
INSERT INTO base_city VALUES ('350200', '350000', '厦门市', 'XM', '2');
INSERT INTO base_city VALUES ('350300', '350000', '莆田市', 'PT', '3');
INSERT INTO base_city VALUES ('350400', '350000', '三明市', 'SM', '3');
INSERT INTO base_city VALUES ('350500', '350000', '泉州市', 'QZ', '3');
INSERT INTO base_city VALUES ('350600', '350000', '漳州市', 'ZZ', '3');
INSERT INTO base_city VALUES ('350700', '350000', '南平市', 'NP', '3');
INSERT INTO base_city VALUES ('350800', '350000', '龙岩市', 'LY', '3');
INSERT INTO base_city VALUES ('350900', '350000', '宁德市', 'ND', '3');
INSERT INTO base_city VALUES ('360100', '360000', '南昌市', 'NC', '2');
INSERT INTO base_city VALUES ('360200', '360000', '景德镇市', 'JD', '4');
INSERT INTO base_city VALUES ('360300', '360000', '萍乡市', 'PX', '5');
INSERT INTO base_city VALUES ('360400', '360000', '九江市', 'JJ', '3');
INSERT INTO base_city VALUES ('360500', '360000', '新余市', 'XY', '5');
INSERT INTO base_city VALUES ('360600', '360000', '鹰潭市', 'YT', '5');
INSERT INTO base_city VALUES ('360700', '360000', '赣州市', 'GZ', '3');
INSERT INTO base_city VALUES ('360800', '360000', '吉安市', 'JA', '4');
INSERT INTO base_city VALUES ('360900', '360000', '宜春市', 'YC', '4');
INSERT INTO base_city VALUES ('361000', '360000', '抚州市', 'FZ', '4');
INSERT INTO base_city VALUES ('361100', '360000', '上饶市', 'SR', '3');
INSERT INTO base_city VALUES ('370100', '370000', '济南市', 'JN', '2');
INSERT INTO base_city VALUES ('370200', '370000', '青岛市', 'QD', '2');
INSERT INTO base_city VALUES ('370300', '370000', '淄博市', 'ZB', '3');
INSERT INTO base_city VALUES ('370400', '370000', '枣庄市', 'ZZ', '4');
INSERT INTO base_city VALUES ('370500', '370000', '东营市', 'DY', '3');
INSERT INTO base_city VALUES ('370600', '370000', '烟台市', 'YT', '2');
INSERT INTO base_city VALUES ('370700', '370000', '潍坊市', 'HF', '3');
INSERT INTO base_city VALUES ('370800', '370000', '济宁市', 'JN', '3');
INSERT INTO base_city VALUES ('370900', '370000', '泰安市', 'TA', '3');
INSERT INTO base_city VALUES ('371000', '370000', '威海市', 'WH', '3');
INSERT INTO base_city VALUES ('371100', '370000', '日照市', 'RZ', '4');
INSERT INTO base_city VALUES ('371200', '370000', '莱芜市', 'LW', '5');
INSERT INTO base_city VALUES ('371300', '370000', '临沂市', 'LY', '3');
INSERT INTO base_city VALUES ('371400', '370000', '德州市', 'DZ', '4');
INSERT INTO base_city VALUES ('371500', '370000', '聊城市', 'LC', '4');
INSERT INTO base_city VALUES ('371600', '370000', '滨州市', 'BZ', '4');
INSERT INTO base_city VALUES ('371700', '370000', '菏泽市', 'HZ', '4');
INSERT INTO base_city VALUES ('410100', '410000', '郑州市', 'ZZ', '2');
INSERT INTO base_city VALUES ('410200', '410000', '开封市', 'KF', '4');
INSERT INTO base_city VALUES ('410300', '410000', '洛阳市', 'LY', '3');
INSERT INTO base_city VALUES ('410400', '410000', '平顶山市', 'PD', '4');
INSERT INTO base_city VALUES ('410500', '410000', '安阳市', 'AY', '4');
INSERT INTO base_city VALUES ('410600', '410000', '鹤壁市', 'HB', '5');
INSERT INTO base_city VALUES ('410700', '410000', '新乡市', 'XX', '4');
INSERT INTO base_city VALUES ('410800', '410000', '焦作市', 'JZ', '4');
INSERT INTO base_city VALUES ('410900', '410000', '濮阳市', 'PY', '5');
INSERT INTO base_city VALUES ('411000', '410000', '许昌市', 'XC', '4');
INSERT INTO base_city VALUES ('411100', '410000', '漯河市', 'LH', '5');
INSERT INTO base_city VALUES ('411200', '410000', '三门峡市', 'SM', '5');
INSERT INTO base_city VALUES ('411300', '410000', '南阳市', 'NY', '3');
INSERT INTO base_city VALUES ('411400', '410000', '商丘市', 'SQ', '4');
INSERT INTO base_city VALUES ('411500', '410000', '信阳市', 'XY', '4');
INSERT INTO base_city VALUES ('411600', '410000', '周口市', 'ZK', '4');
INSERT INTO base_city VALUES ('411700', '410000', '驻马店市', 'ZM', '4');
INSERT INTO base_city VALUES ('420100', '420000', '武汉市', 'WH', '2');
INSERT INTO base_city VALUES ('420200', '420000', '黄石市', 'HS', '4');
INSERT INTO base_city VALUES ('420300', '420000', '十堰市', 'SY', '4');
INSERT INTO base_city VALUES ('420500', '420000', '宜昌市', 'YC', '3');
INSERT INTO base_city VALUES ('420600', '420000', '襄樊市', 'XF', '5');
INSERT INTO base_city VALUES ('420700', '420000', '鄂州市', 'EZ', '5');
INSERT INTO base_city VALUES ('420800', '420000', '荆门市', 'JM', '5');
INSERT INTO base_city VALUES ('420900', '420000', '孝感市', 'XG', '3');
INSERT INTO base_city VALUES ('421000', '420000', '荆州市', 'JZ', '3');
INSERT INTO base_city VALUES ('421100', '420000', '黄冈市', 'HG', '4');
INSERT INTO base_city VALUES ('421200', '420000', '咸宁市', 'XN', '4');
INSERT INTO base_city VALUES ('421300', '420000', '随州市', 'SZ', '5');
INSERT INTO base_city VALUES ('422800', '420000', '恩施土家族苗族自治州', 'ES', '4');
INSERT INTO base_city VALUES ('429000', '420000', '湖北省省直辖行政单位', 'HB', '5');
INSERT INTO base_city VALUES ('430100', '430000', '长沙市', 'CS', '2');
INSERT INTO base_city VALUES ('430200', '430000', '株洲市', 'ZZ', '3');
INSERT INTO base_city VALUES ('430300', '430000', '湘潭市', 'XT', '4');
INSERT INTO base_city VALUES ('430400', '430000', '衡阳市', 'HY', '3');
INSERT INTO base_city VALUES ('430500', '430000', '邵阳市', 'SY', '4');
INSERT INTO base_city VALUES ('430600', '430000', '岳阳市', 'YY', '3');
INSERT INTO base_city VALUES ('430700', '430000', '常德市', 'CD', '4');
INSERT INTO base_city VALUES ('430800', '430000', '张家界市', 'ZZ', '5');
INSERT INTO base_city VALUES ('430900', '430000', '益阳市', 'YY', '5');
INSERT INTO base_city VALUES ('431000', '430000', '郴州市', 'CZ', '4');
INSERT INTO base_city VALUES ('431100', '430000', '永州市', 'YZ', '5');
INSERT INTO base_city VALUES ('431200', '430000', '怀化市', 'HH', '4');
INSERT INTO base_city VALUES ('431300', '430000', '娄底市', 'LD', '4');
INSERT INTO base_city VALUES ('433100', '430000', '湘西土家族苗族自治州', 'XX', '5');
INSERT INTO base_city VALUES ('440100', '440000', '广州市', 'GZ', '1');
INSERT INTO base_city VALUES ('440200', '440000', '韶关市', 'SG', '4');
INSERT INTO base_city VALUES ('440300', '440000', '深圳市', 'SZ', '1');
INSERT INTO base_city VALUES ('440400', '440000', '珠海市', 'ZH', '3');
INSERT INTO base_city VALUES ('440500', '440000', '汕头市', 'ST', '3');
INSERT INTO base_city VALUES ('440600', '440000', '佛山市', 'FS', '2');
INSERT INTO base_city VALUES ('440700', '440000', '江门市', 'JM', '3');
INSERT INTO base_city VALUES ('440800', '440000', '湛江市', 'ZJ', '3');
INSERT INTO base_city VALUES ('440900', '440000', '茂名市', 'MM', '4');
INSERT INTO base_city VALUES ('441200', '440000', '肇庆市', 'ZQ', '3');
INSERT INTO base_city VALUES ('441300', '440000', '惠州市', 'HZ', '3');
INSERT INTO base_city VALUES ('441400', '440000', '梅州市', 'MZ', '4');
INSERT INTO base_city VALUES ('441500', '440000', '汕尾市', 'SW', '4');
INSERT INTO base_city VALUES ('441600', '440000', '河源市', 'HY', '4');
INSERT INTO base_city VALUES ('441700', '440000', '阳江市', 'YJ', '4');
INSERT INTO base_city VALUES ('441800', '440000', '清远市', 'QY', '3');
INSERT INTO base_city VALUES ('441900', '440000', '东莞市', 'DG', '2');
INSERT INTO base_city VALUES ('442000', '440000', '中山市', 'ZS', '3');
INSERT INTO base_city VALUES ('445100', '440000', '潮州市', 'CZ', '4');
INSERT INTO base_city VALUES ('445200', '440000', '揭阳市', 'JY', '3');
INSERT INTO base_city VALUES ('445300', '440000', '云浮市', 'YF', '5');
INSERT INTO base_city VALUES ('450100', '450000', '南宁市', 'NN', '2');
INSERT INTO base_city VALUES ('450200', '450000', '柳州市', 'LZ', '3');
INSERT INTO base_city VALUES ('450300', '450000', '桂林市', 'GL', '3');
INSERT INTO base_city VALUES ('450400', '450000', '梧州市', 'WZ', '4');
INSERT INTO base_city VALUES ('450500', '450000', '北海市', 'BH', '4');
INSERT INTO base_city VALUES ('450600', '450000', '防城港市', 'FC', '5');
INSERT INTO base_city VALUES ('450700', '450000', '钦州市', 'QZ', '5');
INSERT INTO base_city VALUES ('450800', '450000', '贵港市', 'GG', '5');
INSERT INTO base_city VALUES ('450900', '450000', '玉林市', 'YL', '4');
INSERT INTO base_city VALUES ('451000', '450000', '百色市', 'BS', '5');
INSERT INTO base_city VALUES ('451100', '450000', '贺州市', 'HZ', '5');
INSERT INTO base_city VALUES ('451200', '450000', '河池市', 'HC', '5');
INSERT INTO base_city VALUES ('451300', '450000', '来宾市', 'LB', '5');
INSERT INTO base_city VALUES ('451400', '450000', '崇左市', 'CZ', '5');
INSERT INTO base_city VALUES ('460100', '460000', '海口市', 'HK', '3');
INSERT INTO base_city VALUES ('460200', '460000', '三亚市', 'SY', '3');
INSERT INTO base_city VALUES ('469000', '460000', '海南省省直辖县级行政单位', 'HN', '5');
INSERT INTO base_city VALUES ('500001', '500000', '重庆市', 'CQ', '2');
INSERT INTO base_city VALUES ('510100', '510000', '成都市', 'CD', '2');
INSERT INTO base_city VALUES ('510300', '510000', '自贡市', 'ZG', '5');
INSERT INTO base_city VALUES ('510400', '510000', '攀枝花市', 'PZ', '5');
INSERT INTO base_city VALUES ('510500', '510000', '泸州市', 'LZ', '4');
INSERT INTO base_city VALUES ('510600', '510000', '德阳市', 'DY', '4');
INSERT INTO base_city VALUES ('510700', '510000', '绵阳市', 'MY', '3');
INSERT INTO base_city VALUES ('510800', '510000', '广元市', 'GY', '5');
INSERT INTO base_city VALUES ('510900', '510000', '遂宁市', 'SN', '4');
INSERT INTO base_city VALUES ('511000', '510000', '内江市', 'NJ', '4');
INSERT INTO base_city VALUES ('511100', '510000', '乐山市', 'LS', '4');
INSERT INTO base_city VALUES ('511300', '510000', '南充市', 'NC', '3');
INSERT INTO base_city VALUES ('511400', '510000', '眉山市', 'MS', '4');
INSERT INTO base_city VALUES ('511500', '510000', '宜宾市', 'YB', '4');
INSERT INTO base_city VALUES ('511600', '510000', '广安市', 'GA', '5');
INSERT INTO base_city VALUES ('511700', '510000', '达州市', 'DZ', '5');
INSERT INTO base_city VALUES ('511800', '510000', '雅安市', 'YA', '4');
INSERT INTO base_city VALUES ('511900', '510000', '巴中市', 'BZ', '5');
INSERT INTO base_city VALUES ('512000', '510000', '资阳市', 'ZY', '5');
INSERT INTO base_city VALUES ('513200', '510000', '阿坝藏族羌族自治州', 'AB', '5');
INSERT INTO base_city VALUES ('513300', '510000', '甘孜藏族自治州', 'GZ', '5');
INSERT INTO base_city VALUES ('513400', '510000', '凉山彝族自治州', 'LS', '5');
INSERT INTO base_city VALUES ('520100', '520000', '贵阳市', 'GY', '3');
INSERT INTO base_city VALUES ('520200', '520000', '六盘水市', 'LP', '5');
INSERT INTO base_city VALUES ('520300', '520000', '遵义市', 'ZY', '4');
INSERT INTO base_city VALUES ('520400', '520000', '安顺市', 'AS', '5');
INSERT INTO base_city VALUES ('522200', '520000', '铜仁地区', 'TR', '5');
INSERT INTO base_city VALUES ('522300', '520000', '黔西南布依族苗族自治州', 'QX', '5');
INSERT INTO base_city VALUES ('522400', '520000', '毕节地区', 'BJ', '5');
INSERT INTO base_city VALUES ('522600', '520000', '黔东南苗族侗族自治州', 'QD', '4');
INSERT INTO base_city VALUES ('522700', '520000', '黔南布依族苗族自治州', 'QN', '4');
INSERT INTO base_city VALUES ('530100', '530000', '昆明市', 'KM', '2');
INSERT INTO base_city VALUES ('530300', '530000', '曲靖市', 'QJ', '4');
INSERT INTO base_city VALUES ('530400', '530000', '玉溪市', 'YX', '4');
INSERT INTO base_city VALUES ('530500', '530000', '保山市', 'BS', '5');
INSERT INTO base_city VALUES ('530600', '530000', '昭通市', 'ZT', '5');
INSERT INTO base_city VALUES ('530700', '530000', '丽江市', 'LJ', '3');
INSERT INTO base_city VALUES ('530800', '530000', '思茅市', 'SM', '5');
INSERT INTO base_city VALUES ('530900', '530000', '临沧市', 'LC', '5');
INSERT INTO base_city VALUES ('532300', '530000', '楚雄彝族自治州', 'CX', '5');
INSERT INTO base_city VALUES ('532500', '530000', '红河哈尼族彝族自治州', 'HH', '4');
INSERT INTO base_city VALUES ('532600', '530000', '文山壮族苗族自治州', 'WS', '5');
INSERT INTO base_city VALUES ('532800', '530000', '西双版纳傣族自治州', 'XS', '4');
INSERT INTO base_city VALUES ('532900', '530000', '大理白族自治州', 'DL', '4');
INSERT INTO base_city VALUES ('533100', '530000', '德宏傣族景颇族自治州', 'DH', '5');
INSERT INTO base_city VALUES ('533300', '530000', '怒江傈僳族自治州', 'NJ', '5');
INSERT INTO base_city VALUES ('533400', '530000', '迪庆藏族自治州', 'DQ', '5');
INSERT INTO base_city VALUES ('540100', '540000', '拉萨市', 'LS', '5');
INSERT INTO base_city VALUES ('542100', '540000', '昌都地区', 'CD', '5');
INSERT INTO base_city VALUES ('542200', '540000', '山南地区', 'SN', '5');
INSERT INTO base_city VALUES ('542300', '540000', '日喀则地区', 'RK', '5');
INSERT INTO base_city VALUES ('542400', '540000', '那曲地区', 'NQ', '5');
INSERT INTO base_city VALUES ('542500', '540000', '阿里地区', 'AL', '5');
INSERT INTO base_city VALUES ('542600', '540000', '林芝地区', 'LZ', '5');
INSERT INTO base_city VALUES ('610100', '610000', '西安市', 'XA', '2');
INSERT INTO base_city VALUES ('610200', '610000', '铜川市', 'TC', '5');
INSERT INTO base_city VALUES ('610300', '610000', '宝鸡市', 'BJ', '4');
INSERT INTO base_city VALUES ('610400', '610000', '咸阳市', 'XY', '3');
INSERT INTO base_city VALUES ('610500', '610000', '渭南市', 'WN', '4');
INSERT INTO base_city VALUES ('610600', '610000', '延安市', 'YA', '5');
INSERT INTO base_city VALUES ('610700', '610000', '汉中市', 'HZ', '5');
INSERT INTO base_city VALUES ('610800', '610000', '榆林市', 'YL', '4');
INSERT INTO base_city VALUES ('610900', '610000', '安康市', 'AK', '5');
INSERT INTO base_city VALUES ('611000', '610000', '商洛市', 'SL', '5');
INSERT INTO base_city VALUES ('620100', '620000', '兰州市', 'LZ', '3');
INSERT INTO base_city VALUES ('620200', '620000', '嘉峪关市', 'JY', '5');
INSERT INTO base_city VALUES ('620300', '620000', '金昌市', 'JC', '5');
INSERT INTO base_city VALUES ('620400', '620000', '白银市', 'BY', '5');
INSERT INTO base_city VALUES ('620500', '620000', '天水市', 'TS', '5');
INSERT INTO base_city VALUES ('620600', '620000', '武威市', 'WW', '5');
INSERT INTO base_city VALUES ('620700', '620000', '张掖市', 'ZY', '5');
INSERT INTO base_city VALUES ('620800', '620000', '平凉市', 'PL', '5');
INSERT INTO base_city VALUES ('620900', '620000', '酒泉市', 'JQ', '5');
INSERT INTO base_city VALUES ('621000', '620000', '庆阳市', 'QY', '5');
INSERT INTO base_city VALUES ('621100', '620000', '定西市', 'DX', '5');
INSERT INTO base_city VALUES ('621200', '620000', '陇南市', 'LN', '5');
INSERT INTO base_city VALUES ('622900', '620000', '临夏回族自治州', 'LX', '5');
INSERT INTO base_city VALUES ('623000', '620000', '甘南藏族自治州', 'GN', '5');
INSERT INTO base_city VALUES ('630100', '630000', '西宁市', 'XN', '3');
INSERT INTO base_city VALUES ('632100', '630000', '海东地区', 'HD', '5');
INSERT INTO base_city VALUES ('632200', '630000', '海北藏族自治州', 'HB', '5');
INSERT INTO base_city VALUES ('632300', '630000', '黄南藏族自治州', 'HN', '5');
INSERT INTO base_city VALUES ('632500', '630000', '海南藏族自治州', 'HN', '5');
INSERT INTO base_city VALUES ('632600', '630000', '果洛藏族自治州', 'GL', '5');
INSERT INTO base_city VALUES ('632700', '630000', '玉树藏族自治州', 'YS', '5');
INSERT INTO base_city VALUES ('632800', '630000', '海西蒙古族藏族自治州', 'HX', '5');
INSERT INTO base_city VALUES ('640100', '640000', '银川市', 'YC', '3');
INSERT INTO base_city VALUES ('640200', '640000', '石嘴山市', 'SZ', '5');
INSERT INTO base_city VALUES ('640300', '640000', '吴忠市', 'WZ', '5');
INSERT INTO base_city VALUES ('640400', '640000', '固原市', 'GY', '5');
INSERT INTO base_city VALUES ('640500', '640000', '中卫市', 'ZW', '5');
INSERT INTO base_city VALUES ('650100', '650000', '乌鲁木齐市', 'WL', '3');
INSERT INTO base_city VALUES ('650200', '650000', '克拉玛依市', 'KL', '5');
INSERT INTO base_city VALUES ('652100', '650000', '吐鲁番地区', 'TL', '5');
INSERT INTO base_city VALUES ('652200', '650000', '哈密地区', 'HM', '5');
INSERT INTO base_city VALUES ('652300', '650000', '昌吉回族自治州', 'CJ', '5');
INSERT INTO base_city VALUES ('652700', '650000', '博尔塔拉蒙古自治州', 'BE', '5');
INSERT INTO base_city VALUES ('652800', '650000', '巴音郭楞蒙古自治州', 'BY', '5');
INSERT INTO base_city VALUES ('652900', '650000', '阿克苏地区', 'AK', '5');
INSERT INTO base_city VALUES ('653000', '650000', '克孜勒苏柯尔克孜自治州', 'KZ', '5');
INSERT INTO base_city VALUES ('653100', '650000', '喀什地区', 'KS', '5');
INSERT INTO base_city VALUES ('653200', '650000', '和田地区', 'HT', '5');
INSERT INTO base_city VALUES ('654000', '650000', '伊犁哈萨克自治州', 'YL', '5');
INSERT INTO base_city VALUES ('654200', '650000', '塔城地区', 'TC', '5');
INSERT INTO base_city VALUES ('654300', '650000', '阿勒泰地区', 'AL', '5');

转载于:https://www.cnblogs.com/markw116/p/7148796.html

你可能感兴趣的文章
linux程序设计---序
查看>>
【字符串入门专题1】hdu3613 【一个悲伤的exkmp】
查看>>
C# Linq获取两个List或数组的差集交集
查看>>
HDU 4635 Strongly connected
查看>>
ASP.NET/C#获取文章中图片的地址
查看>>
Spring MVC 入门(二)
查看>>
格式化输出数字和时间
查看>>
页面中公用的全选按钮,单选按钮组件的编写
查看>>
java笔记--用ThreadLocal管理线程,Callable<V>接口实现有返回值的线程
查看>>
BZOJ 1047 HAOI2007 理想的正方形 单调队列
查看>>
各种语言推断是否是手机设备
查看>>
这个看起来有点简单!--------实验吧
查看>>
PHP count down
查看>>
JVM参数调优:Eclipse启动实践
查看>>
(旧笔记搬家)struts.xml中单独页面跳转的配置
查看>>
不定期周末福利:数据结构与算法学习书单
查看>>
strlen函数
查看>>
python的列表与shell的数组
查看>>
关于TFS2010使用常见问题
查看>>
软件工程团队作业3
查看>>