MySql全国省市区SQL语句CREATE TABLE IF NOT EXISTS `province` ( `id` int(11) NOT NULL auto_increment,
`provinceID` int(11) NOT NULL,
`province` varchar(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=INNODB CHARSET=UTF8;
INSERT INTO `province` (`id`, `provinceID`, `province`) VALUES
(1, 110000, '北京市'),
(2, 120000, '天津市'),
(3, 130000, '河北省'),
(4, 140000, '⼭西省'),
(6, 210000, '辽宁省'),
(7, 220000, '吉林省'),
(8, 230000, '⿊龙江省'),
(9, 310000, '上海市'),
(10, 320000, '江苏省'),
(11, 330000, '浙江省'),
(12, 340000, '安徽省'),
(13, 350000, '福建省'),
(14, 360000, '江西省'),
(15, 370000, '⼭东省'),
(16, 410000, '河南省'),
(17, 420000, '湖北省'),
(18, 430000, '湖南省'),
(19, 440000, '⼴东省'),
(20, 450000, '⼴西壮族⾃治区'),
(21, 460000, '海南省'),
(22, 500000, '重庆市'),
(23, 510000, '四川省'),
(24, 520000, '贵州省'),
(25, 530000, '云南省'),
(26, 540000, '西藏⾃治区'),
(27, 610000, '陕西省'),
(28, 620000, '⽢肃省'),
(29, 630000, '青海省'),
(30, 640000, '宁夏回族⾃治区'),
(31, 650000, '新疆维吾尔⾃治区'),
(32, 710000, '台湾省'),
(33, 810000, '⾹港特别⾏政区'),
CREATE TABLE IF NOT EXISTS `city` (
`id` int(11) NOT NULL auto_increment,
`cityID` int(11) NOT NULL,
`city` varchar(20) NOT NULL,
`fatherID` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=INNODB CHARSET=UTF8;
INSERT INTO `city` (`id`, `cityID`, `city`, `fatherID`) VALUES
(1, 110100, '市辖区', 110000),
(2, 110200, '县', 110000),
(3, 120100, '市辖区', 120000),
(4, 120200, '县', 120000),
(5, 130100, '⽯家庄市', 130000),
(6, 130200, '唐⼭市', 130000),
(7, 130300, '秦皇岛市', 130000),
(8, 130400, '邯郸市', 130000),
(17, 140200, '⼤同市', 140000),
(18, 140300, '阳泉市', 140000),
(19, 140400, '长治市', 140000),
(20, 140500, '晋城市', 140000),
(21, 140600, '朔州市', 140000),
(22, 140700, '晋中市', 140000),
(23, 140800, '运城市', 140000),
(24, 140900, '忻州市', 140000),
(25, 141000, '临汾市', 140000),
(26, 141100, '吕梁市', 140000),
(27, 150100, '呼和浩特市', 150000), (28, 150200, '包头市', 150000),
(29, 150300, '乌海市', 150000),
(30, 150400, '⾚峰市', 150000),
(31, 150500, '通辽市', 150000),
(32, 150600, '鄂尔多斯市', 150000), (33, 150700, '呼伦贝尔市', 150000), (34, 150800, '巴彦淖尔市', 150000), (35, 150900, '乌兰察布市', 150000), (36, 152200, '兴安盟', 150000),
(37, 152500, '锡林郭勒盟', 150000), (38, 152900, '阿拉善盟', 150000), (39, 210100, '沈阳市', 210000),
(40, 210200, '⼤连市', 210000),
(41, 210300, '鞍⼭市', 210000),
(42, 210400, '抚顺市', 210000),
(43, 210500, '本溪市', 210000),
(44, 210600, '丹东市', 210000),
(45, 210700, '锦州市', 210000),
(46, 210800, '营⼝市', 210000),
(47, 210900, '⾩新市', 210000),
(48, 211000, '辽阳市', 210000),
(49, 211100, '盘锦市', 210000),
(50, 211200, '铁岭市', 210000),
(51, 211300, '朝阳市', 210000),
(52, 211400, '葫芦岛市', 210000), (53, 220100, '长春市', 220000),
(54, 220200, '吉林市', 220000),
(55, 220300, '四平市', 220000),
(56, 220400, '辽源市', 220000),
(57, 220500, '通化市', 220000),
(58, 220600, '⽩⼭市', 220000),
(59, 220700, '松原市', 220000),
(60, 220800, '⽩城市', 220000),
(61, 222400, '延边朝鲜族⾃治州', 220000), (62, 230100, '哈尔滨市', 230000), (63, 230200, '齐齐哈尔市', 230000), (64, 230300, '鸡西市', 230000), (65, 230400, '鹤岗市', 230000),
(66, 230500, '双鸭⼭市', 230000), (67, 230600, '⼤庆市', 230000),
(68, 230700, '伊春市', 230000),
(69, 230800, '佳⽊斯市', 230000), (70, 230900, '七台河市', 230000), (71, 231000, '牡丹江市', 230000), (72, 231100, '⿊河市', 230000),
(73, 231200, '绥化市', 230000),
(74, 232700, '⼤兴安岭地区', 230000), (75, 310100, '市辖区', 310000), (76, 310200, '县', 310000),
(85, 320900, '盐城市', 320000), (86, 321000, '扬州市', 320000), (87, 321100, '镇江市', 320000), (88, 321200, '泰州市', 320000), (89, 321300, '宿迁市', 320000), (90, 330100, '杭州市', 330000), (91, 330200, '宁波市', 330000), (92, 330300, '温州市', 330000), (93, 330400, '嘉兴市', 330000), (94, 330500, '湖州市', 330000), (95, 330600, '绍兴市', 330000), (96, 330700, '⾦华市', 330000), (97, 330800, '衢州市', 330000), (98, 330900, '⾈⼭市', 330000), (99, 331000, '台州市', 330000), (100, 331100, '丽⽔市', 330000), (101, 340100, '合肥市', 340000), (102, 340200, '芜湖市', 340000), (103, 340300, '蚌埠市', 340000), (104, 340400, '淮南市', 340000), (105, 340500, '马鞍⼭市', 340000), (106, 340600, '淮北市', 340000), (107, 340700, '铜陵市', 340000), (108, 340800, '安庆市', 340000), (109, 341000, '黄⼭市', 340000), (110, 341100, '滁州市', 340000), (111, 341200, '⾩阳市', 340000), (112, 341300, '宿州市', 340000), (113, 341400, '巢湖市', 340000), (114, 341500, '六安市', 340000), (115, 341600, '亳州市', 340000), (116, 341700, '池州市', 340000), (117, 341800, '宣城市', 340000), (118, 350100, '福州市', 350000), (119, 350200, '厦门市', 350000), (120, 350300, '莆⽥市', 350000), (121, 350
400, '三明市', 350000), (122, 350500, '泉州市', 350000), (123, 350600, '漳州市', 350000), (124, 350700, '南平市', 350000), (125, 350800, '龙岩市', 350000), (126, 350900, '宁德市', 350000), (127, 360100, '南昌市', 360000), (128, 360200, '景德镇市', 360000), (129, 360300, '萍乡市', 360000), (130, 360400, '九江市', 360000), (131, 360500, '新余市', 360000), (132, 360600, '鹰潭市', 360000), (133, 360700, '赣州市', 360000), (134, 360800, '吉安市', 360000), (135, 360900, '宜春市', 360000), (136, 361000, '抚州市', 360000), (137, 361100, '上饶市', 360000), (138, 370100, '济南市', 370000), (139, 370200, '青岛市', 370000), (140, 370300, '淄博市', 370000), (141, 370400, '枣庄市', 370000), (142, 370500, '东营市', 370000), (143, 370600, '烟台市', 370000), (144, 370700, '潍坊市', 370000),
(153, 371600, '滨州市', 370000),
(154, 371700, '荷泽市', 370000),
(155, 410100, '郑州市', 410000),
(156, 410200, '开封市', 410000),
(157, 410300, '洛阳市', 410000),
(158, 410400, '平顶⼭市', 410000),
(159, 410500, '安阳市', 410000),
(160, 410600, '鹤壁市', 410000),
(161, 410700, '新乡市', 410000),
(162, 410800, '焦作市', 410000),
(163, 410900, '濮阳市', 410000),
(164, 411000, '许昌市', 410000),
(165, 411100, '漯河市', 410000),
(166, 411200, '三门峡市', 410000),
(167, 411300, '南阳市', 410000),
(168, 411400, '商丘市', 410000),
(169, 411500, '信阳市', 410000),
(170, 411600, '周⼝市', 410000),
(171, 411700, '驻马店市', 410000),
(172, 420100, '武汉市', 420000),
(173, 420200, '黄⽯市', 420000),
(174, 420300, '⼗堰市', 420000),
(175, 420500, '宜昌市', 420000),
(176, 420600, '襄樊市', 420000),
(177, 420700, '鄂州市', 420000),
(178, 420800, '荆门市', 420000),
(179, 420900, '孝感市', 420000),
(180, 421000, '荆州市', 420000),
(181, 421100, '黄冈市', 420000),
(182, 421200, '咸宁市', 420000),
(183, 421300, '随州市', 420000),
(184, 422800, '恩施⼟家族苗族⾃治州', 420000), (185, 429000, '省直辖⾏政单位', 420000), (186, 430100, '长沙市', 430000),
(187, 430200, '株洲市', 430000),
(188, 430300, '湘潭市', 430000),
(189, 430400, '衡阳市', 430000),
(190, 430500, '邵阳市', 430000),
(191, 430600, '岳阳市', 430000),
(192, 430700, '常德市', 430000),
(193, 430800, '张家界市', 430000),
(194, 430900, '益阳市', 430000),
(195, 431000, '郴州市', 430000),
(196, 431100, '永州市', 430000),
(197, 431200, '怀化市', 430000),
(198, 431300, '娄底市', 430000),
(199, 433100, '湘西⼟家族苗族⾃治州', 430000), (200, 440100, '⼴州市', 440000),
(201, 440200, '韶关市', 440000),
(202, 440300, '深圳市', 440000),
(203, 440400, '珠海市', 440000),
(204, 440500, '汕头市', 440000),
(205, 440600, '佛⼭市', 440000),
(206, 440700, '江门市', 440000),
(207, 440800, '湛江市', 440000),
(208, 440900, '茂名市', 440000),
(209, 441200, '肇庆市', 440000),
(210, 441300, '惠州市', 440000),
(211, 441400, '梅州市', 440000),
(212, 441500, '汕尾市', 440000),
(221, 450100, '南宁市', 450000),
(222, 450200, '柳州市', 450000),
(223, 450300, '桂林市', 450000),
(224, 450400, '梧州市', 450000),
(225, 450500, '北海市', 450000),
(226, 450600, '防城港市', 450000),
(227, 450700, '钦州市', 450000),
(228, 450800, '贵港市', 450000),
(229, 450900, '⽟林市', 450000),
(230, 451000, '百⾊市', 450000),
(231, 451100, '贺州市', 450000),
(232, 451200, '河池市', 450000),
(233, 451300, '来宾市', 450000),
(234, 451400, '崇左市', 450000),
(235, 460100, '海⼝市', 460000),
(236, 460200, '三亚市', 460000),
(237, 469000, '省直辖县级⾏政单位', 460000), (238, 500100, '市辖区', 500000),
(239, 500200, '县', 500000),
(240, 500300, '市', 500000),
(241, 510100, '成都市', 510000),
(242, 510300, '⾃贡市', 510000),
(243, 510400, '攀枝花市', 510000),
(244, 510500, '泸州市', 510000),
(245, 510600, '德阳市', 510000),
(246, 510700, '绵阳市', 510000),
(247, 510800, '⼴元市', 510000),
(248, 510900, '遂宁市', 510000),
(249, 511000, '内江市', 510000),
(250, 511100, '乐⼭市', 510000),
(251, 511300, '南充市', 510000),
(252, 511400, '眉⼭市', 510000),
(253, 511500, '宜宾市', 510000),
(254, 511600, '⼴安市', 510000),
(255, 511700, '达州市', 510000),
(256, 511800, '雅安市', 510000),
(257, 511900, '巴中市', 510000),
(258, 512000, '资阳市', 510000),
(259, 513200, '阿坝藏族羌族⾃治州', 510000), (260, 513300, '⽢孜藏族⾃治州', 510000), (261, 513400, '凉⼭彝族⾃治州', 510000), (262, 520100, '贵阳市', 520000),
(263, 520200, '六盘⽔市', 520000),
(264, 520300, '遵义市', 520000),
(265, 520400, '安顺市', 520000),
(266, 522200, '铜仁地区', 520000),
(267, 522300, '黔西南布依族苗族⾃治州', 520000), (268, 522400, '毕节地区', 520000),
(269, 522600, '黔东南苗族侗族⾃治州', 520000), (270, 522700, '黔南布依族苗族⾃治州', 520000), (271, 530100, '昆明市', 530000),
(272, 530300, '曲靖市', 530000),
(273, 530400, '⽟溪市', 530000),
(274, 530500, '保⼭市', 530000),
(275, 530600, '昭通市', 530000),
(276, 530700, '丽江市', 530000),
(277, 530800, '思茅市', 530000),
(278, 530900, '临沧市', 530000),
(279, 532300, '楚雄彝族⾃治州', 530000), (280, 532500, '红河哈尼族彝族⾃治州', 530000),
豫公网安备41160202000603
站长QQ:729038198
关于我们
投诉建议