精华内容
下载资源
问答
  • 省市区数据库级联查询所用数据,旗舰版全数据,2018全数据
  • 基于mysql搜集的省市区数据库数据;可用于做三级联动数据;可能数据不全。
  • mysql省市区三级联动
  • html 省市区三级联动数据库 html中实现三级联动是一个不错的demo,博主在这里跟大家分享一下实现的过程,以及自己在过程中出现的一些问题,仅供参考。  首先我们将全国的省市区数据导入进来,这里已经直接整理...
  • 此文件为sql文件,可直接导入使用。 能够实现比较简单的三级联动
  • mysql省市区三级联动数据库表,数据库值可动态增加。
  • 2021最新全国省市县区三级联动数据库表, 2021年最新爬取的淘宝收货地址(菜鸟4级网络),网络上最新最全的省市县对应表
  • 配合博文【MVC4.0搭建的省市县三联动】安装的数据库 博文地址:http://blog.csdn.net/qq_17202783/article/details/43371421
  • 2020最新全国省市县区三级联动数据库表, 2020年最新爬取的淘宝收货地址(菜鸟4级网络),网络上最新最全的省市县对应表
  • 省市区三级联动数据库,包括全国所有省市区数据以及关系
  • 项目内一直在用,仅一张表无需连表查询,使用国家code码。
  • 省市城市区三级联动,有详细的SQL代码,创建表代码、插入代码,简单好用,也是最新的省市区划分。
  • 2021年从国家统计局数据 对于教程 方案一 https://blog.csdn.net/tangcv/article/details/117288987
  • PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=346 DEFAULT CHARSET=utf8 COMMENT='城市信息表' : CREATE TABLE `areas` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `areaid` char(6) NOT ...

    一:创建表

    省:

    CREATE TABLE `provinces` (
       `id` int(11) NOT NULL AUTO_INCREMENT,
       `provinceid` int(11) NOT NULL,
       `province` varchar(100) NOT NULL DEFAULT '',
       PRIMARY KEY (`id`)
     ) ENGINE=MyISAM AUTO_INCREMENT=392 DEFAULT CHARSET=utf8

    市:

    CREATE TABLE `cities` (
       `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
       `cityid` char(6) NOT NULL COMMENT '城市编码',
       `city` varchar(40) NOT NULL COMMENT '城市名称',
       `provinceid` char(6) NOT NULL COMMENT '所属省份编码',
       PRIMARY KEY (`id`)
     ) ENGINE=InnoDB AUTO_INCREMENT=346 DEFAULT CHARSET=utf8 COMMENT='城市信息表'

    区:

    CREATE TABLE `areas` (
       `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
       `areaid` char(6) NOT NULL COMMENT '区县编码',
       `area` varchar(40) NOT NULL COMMENT '区县名称',
       `cityid` char(6) NOT NULL COMMENT '所属城市编码',
       PRIMARY KEY (`id`)
     ) ENGINE=InnoDB AUTO_INCREMENT=3145 DEFAULT CHARSET=utf8 COMMENT='区县信息表'

    二:新增数据

    省:

    INSERT INTO `provinces` VALUES ('1', '110000', '北京市'); 
    INSERT INTO `provinces` VALUES ('2', '120000', '天津市'); 
    INSERT INTO `provinces` VALUES ('3', '130000', '河北省'); 
    INSERT INTO `provinces` VALUES ('4', '140000', '山西省'); 
    INSERT INTO `provinces` VALUES ('5', '150000', '内蒙古自治区'); 
    INSERT INTO `provinces` VALUES ('6', '210000', '辽宁省'); 
    INSERT INTO `provinces` VALUES ('7', '220000', '吉林省'); 
    INSERT INTO `provinces` VALUES ('8', '230000', '黑龙江省'); 
    INSERT INTO `provinces` VALUES ('9', '310000', '上海市'); 
    INSERT INTO `provinces` VALUES ('10', '320000', '江苏省'); 
    INSERT INTO `provinces` VALUES ('11', '330000', '浙江省'); 
    INSERT INTO `provinces` VALUES ('12', '340000', '安徽省'); 
    INSERT INTO `provinces` VALUES ('13', '350000', '福建省'); 
    INSERT INTO `provinces` VALUES ('14', '360000', '江西省'); 
    INSERT INTO `provinces` VALUES ('15', '370000', '山东省'); 
    INSERT INTO `provinces` VALUES ('16', '410000', '河南省'); 
    INSERT INTO `provinces` VALUES ('17', '420000', '湖北省'); 
    INSERT INTO `provinces` VALUES ('18', '430000', '湖南省'); 
    INSERT INTO `provinces` VALUES ('19', '440000', '广东省'); 
    INSERT INTO `provinces` VALUES ('20', '450000', '广西壮族自治区'); 
    INSERT INTO `provinces` VALUES ('21', '460000', '海南省'); 
    INSERT INTO `provinces` VALUES ('22', '500000', '重庆市'); 
    INSERT INTO `provinces` VALUES ('23', '510000', '四川省'); 
    INSERT INTO `provinces` VALUES ('24', '520000', '贵州省'); 
    INSERT INTO `provinces` VALUES ('25', '530000', '云南省'); 
    INSERT INTO `provinces` VALUES ('26', '540000', '西藏自治区'); 
    INSERT INTO `provinces` VALUES ('27', '610000', '陕西省'); 
    INSERT INTO `provinces` VALUES ('28', '620000', '甘肃省'); 
    INSERT INTO `provinces` VALUES ('29', '630000', '青海省'); 
    INSERT INTO `provinces` VALUES ('30', '640000', '宁夏回族自治区'); 
    INSERT INTO `provinces` VALUES ('31', '650000', '新疆维吾尔自治区'); 
    INSERT INTO `provinces` VALUES ('32', '710000', '台湾省'); 
    INSERT INTO `provinces` VALUES ('33', '810000', '香港特别行政区'); 
    INSERT INTO `provinces` VALUES ('34', '820000', '澳门特别行政区');

    市:

    INSERT INTO `cities` VALUES ('1', '110100', '北京市', '110000'); 
    INSERT INTO `cities` VALUES ('2', '1102xx', '北京下属县', '1100xx'); 
    INSERT INTO `cities` VALUES ('3', '120100', '天津市', '120000'); 
    INSERT INTO `cities` VALUES ('4', '1202xx', '天津下属县', '1200xx'); 
    INSERT INTO `cities` VALUES ('5', '130100', '石家庄市', '130000'); 
    INSERT INTO `cities` VALUES ('6', '130200', '唐山市', '130000'); 
    INSERT INTO `cities` VALUES ('7', '130300', '秦皇岛市', '130000'); 
    INSERT INTO `cities` VALUES ('8', '130400', '邯郸市', '130000'); 
    INSERT INTO `cities` VALUES ('9', '130500', '邢台市', '130000'); 
    INSERT INTO `cities` VALUES ('10', '130600', '保定市', '130000'); 
    INSERT INTO `cities` VALUES ('11', '130700', '张家口市', '130000'); 
    INSERT INTO `cities` VALUES ('12', '130800', '承德市', '130000'); 
    INSERT INTO `cities` VALUES ('13', '130900', '沧州市', '130000'); 
    INSERT INTO `cities` VALUES ('14', '131000', '廊坊市', '130000'); 
    INSERT INTO `cities` VALUES ('15', '131100', '衡水市', '130000'); 
    INSERT INTO `cities` VALUES ('16', '140100', '太原市', '140000'); 
    INSERT INTO `cities` VALUES ('17', '140200', '大同市', '140000'); 
    INSERT INTO `cities` VALUES ('18', '140300', '阳泉市', '140000'); 
    INSERT INTO `cities` VALUES ('19', '140400', '长治市', '140000'); 
    INSERT INTO `cities` VALUES ('20', '140500', '晋城市', '140000'); 
    INSERT INTO `cities` VALUES ('21', '140600', '朔州市', '140000'); 
    INSERT INTO `cities` VALUES ('22', '140700', '晋中市', '140000'); 
    INSERT INTO `cities` VALUES ('23', '140800', '运城市', '140000'); 
    INSERT INTO `cities` VALUES ('24', '140900', '忻州市', '140000'); 
    INSERT INTO `cities` VALUES ('25', '141000', '临汾市', '140000'); 
    INSERT INTO `cities` VALUES ('26', '141100', '吕梁市', '140000'); 
    INSERT INTO `cities` VALUES ('27', '150100', '呼和浩特市', '150000'); 
    INSERT INTO `cities` VALUES ('28', '150200', '包头市', '150000'); 
    INSERT INTO `cities` VALUES ('29', '150300', '乌海市', '150000'); 
    INSERT INTO `cities` VALUES ('30', '150400', '赤峰市', '150000'); 
    INSERT INTO `cities` VALUES ('31', '150500', '通辽市', '150000'); 
    INSERT INTO `cities` VALUES ('32', '150600', '鄂尔多斯市', '150000'); 
    INSERT INTO `cities` VALUES ('33', '150700', '呼伦贝尔市', '150000'); 
    INSERT INTO `cities` VALUES ('34', '150800', '巴彦淖尔市', '150000'); 
    INSERT INTO `cities` VALUES ('35', '150900', '乌兰察布市', '150000'); 
    INSERT INTO `cities` VALUES ('36', '152200', '兴安盟', '150000'); 
    INSERT INTO `cities` VALUES ('37', '152500', '锡林郭勒盟', '150000'); 
    INSERT INTO `cities` VALUES ('38', '152900', '阿拉善盟', '150000'); 
    INSERT INTO `cities` VALUES ('39', '210100', '沈阳市', '210000'); 
    INSERT INTO `cities` VALUES ('40', '210200', '大连市', '210000'); 
    INSERT INTO `cities` VALUES ('41', '210300', '鞍山市', '210000'); 
    INSERT INTO `cities` VALUES ('42', '210400', '抚顺市', '210000'); 
    INSERT INTO `cities` VALUES ('43', '210500', '本溪市', '210000'); 
    INSERT INTO `cities` VALUES ('44', '210600', '丹东市', '210000'); 
    INSERT INTO `cities` VALUES ('45', '210700', '锦州市', '210000'); 
    INSERT INTO `cities` VALUES ('46', '210800', '营口市', '210000'); 
    INSERT INTO `cities` VALUES ('47', '210900', '阜新市', '210000'); 
    INSERT INTO `cities` VALUES ('48', '211000', '辽阳市', '210000'); 
    INSERT INTO `cities` VALUES ('49', '211100', '盘锦市', '210000'); 
    INSERT INTO `cities` VALUES ('50', '211200', '铁岭市', '210000'); 
    INSERT INTO `cities` VALUES ('51', '211300', '朝阳市', '210000'); 
    INSERT INTO `cities` VALUES ('52', '211400', '葫芦岛市', '210000'); 
    INSERT INTO `cities` VALUES ('53', '220100', '长春市', '220000'); 
    INSERT INTO `cities` VALUES ('54', '220200', '吉林市', '220000'); 
    INSERT INTO `cities` VALUES ('55', '220300', '四平市', '220000'); 
    INSERT INTO `cities` VALUES ('56', '220400', '辽源市', '220000'); 
    INSERT INTO `cities` VALUES ('57', '220500', '通化市', '220000'); 
    INSERT INTO `cities` VALUES ('58', '220600', '白山市', '220000'); 
    INSERT INTO `cities` VALUES ('59', '220700', '松原市', '220000'); 
    INSERT INTO `cities` VALUES ('60', '220800', '白城市', '220000'); 
    INSERT INTO `cities` VALUES ('61', '222400', '延边朝鲜族自治州', '220000'); 
    INSERT INTO `cities` VALUES ('62', '230100', '哈尔滨市', '230000'); 
    INSERT INTO `cities` VALUES ('63', '230200', '齐齐哈尔市', '230000'); 
    INSERT INTO `cities` VALUES ('64', '230300', '鸡西市', '230000'); 
    INSERT INTO `cities` VALUES ('65', '230400', '鹤岗市', '230000'); 
    INSERT INTO `cities` VALUES ('66', '230500', '双鸭山市', '230000'); 
    INSERT INTO `cities` VALUES ('67', '230600', '大庆市', '230000'); 
    INSERT INTO `cities` VALUES ('68', '230700', '伊春市', '230000'); 
    INSERT INTO `cities` VALUES ('69', '230800', '佳木斯市', '230000'); 
    INSERT INTO `cities` VALUES ('70', '230900', '七台河市', '230000'); 
    INSERT INTO `cities` VALUES ('71', '231000', '牡丹江市', '230000'); 
    INSERT INTO `cities` VALUES ('72', '231100', '黑河市', '230000'); 
    INSERT INTO `cities` VALUES ('73', '231200', '绥化市', '230000'); 
    INSERT INTO `cities` VALUES ('74', '232700', '大兴安岭地区', '230000'); 
    INSERT INTO `cities` VALUES ('75', '310100', '上海市', '310000'); 
    INSERT INTO `cities` VALUES ('76', '3102xx', '上海下属县', '3100xx'); 
    INSERT INTO `cities` VALUES ('77', '320100', '南京市', '320000'); 
    INSERT INTO `cities` VALUES ('78', '320200', '无锡市', '320000'); 
    INSERT INTO `cities` VALUES ('79', '320300', '徐州市', '320000'); 
    INSERT INTO `cities` VALUES ('80', '320400', '常州市', '320000'); 
    INSERT INTO `cities` VALUES ('81', '320500', '苏州市', '320000'); 
    INSERT INTO `cities` VALUES ('82', '320600', '南通市', '320000'); 
    INSERT INTO `cities` VALUES ('83', '320700', '连云港市', '320000'); 
    INSERT INTO `cities` VALUES ('84', '320800', '淮安市', '320000'); 
    INSERT INTO `cities` VALUES ('85', '320900', '盐城市', '320000'); 
    INSERT INTO `cities` VALUES ('86', '321000', '扬州市', '320000'); 
    INSERT INTO `cities` VALUES ('87', '321100', '镇江市', '320000'); 
    INSERT INTO `cities` VALUES ('88', '321200', '泰州市', '320000'); 
    INSERT INTO `cities` VALUES ('89', '321300', '宿迁市', '320000'); 
    INSERT INTO `cities` VALUES ('90', '330100', '杭州市', '330000'); 
    INSERT INTO `cities` VALUES ('91', '330200', '宁波市', '330000'); 
    INSERT INTO `cities` VALUES ('92', '330300', '温州市', '330000'); 
    INSERT INTO `cities` VALUES ('93', '330400', '嘉兴市', '330000'); 
    INSERT INTO `cities` VALUES ('94', '330500', '湖州市', '330000'); 
    INSERT INTO `cities` VALUES ('95', '330600', '绍兴市', '330000'); 
    INSERT INTO `cities` VALUES ('96', '330700', '金华市', '330000'); 
    INSERT INTO `cities` VALUES ('97', '330800', '衢州市', '330000'); 
    INSERT INTO `cities` VALUES ('98', '330900', '舟山市', '330000'); 
    INSERT INTO `cities` VALUES ('99', '331000', '台州市', '330000'); 
    INSERT INTO `cities` VALUES ('100', '331100', '丽水市', '330000'); 
    INSERT INTO `cities` VALUES ('101', '340100', '合肥市', '340000'); 
    INSERT INTO `cities` VALUES ('102', '340200', '芜湖市', '340000'); 
    INSERT INTO `cities` VALUES ('103', '340300', '蚌埠市', '340000'); 
    INSERT INTO `cities` VALUES ('104', '340400', '淮南市', '340000'); 
    INSERT INTO `cities` VALUES ('105', '340500', '马鞍山市', '340000'); 
    INSERT INTO `cities` VALUES ('106', '340600', '淮北市', '340000'); 
    INSERT INTO `cities` VALUES ('107', '340700', '铜陵市', '340000'); 
    INSERT INTO `cities` VALUES ('108', '340800', '安庆市', '340000'); 
    INSERT INTO `cities` VALUES ('109', '341000', '黄山市', '340000'); 
    INSERT INTO `cities` VALUES ('110', '341100', '滁州市', '340000'); 
    INSERT INTO `cities` VALUES ('111', '341200', '阜阳市', '340000'); 
    INSERT INTO `cities` VALUES ('112', '341300', '宿州市', '340000'); 
    INSERT INTO `cities` VALUES ('113', '341400', '巢湖市', '340000'); 
    INSERT INTO `cities` VALUES ('114', '341500', '六安市', '340000'); 
    INSERT INTO `cities` VALUES ('115', '341600', '亳州市', '340000'); 
    INSERT INTO `cities` VALUES ('116', '341700', '池州市', '340000'); 
    INSERT INTO `cities` VALUES ('117', '341800', '宣城市', '340000'); 
    INSERT INTO `cities` VALUES ('118', '350100', '福州市', '350000'); 
    INSERT INTO `cities` VALUES ('119', '350200', '厦门市', '350000'); 
    INSERT INTO `cities` VALUES ('120', '350300', '莆田市', '350000'); 
    INSERT INTO `cities` VALUES ('121', '350400', '三明市', '350000'); 
    INSERT INTO `cities` VALUES ('122', '350500', '泉州市', '350000'); 
    INSERT INTO `cities` VALUES ('123', '350600', '漳州市', '350000'); 
    INSERT INTO `cities` VALUES ('124', '350700', '南平市', '350000'); 
    INSERT INTO `cities` VALUES ('125', '350800', '龙岩市', '350000'); 
    INSERT INTO `cities` VALUES ('126', '350900', '宁德市', '350000'); 
    INSERT INTO `cities` VALUES ('127', '360100', '南昌市', '360000'); 
    INSERT INTO `cities` VALUES ('128', '360200', '景德镇市', '360000'); 
    INSERT INTO `cities` VALUES ('129', '360300', '萍乡市', '360000'); 
    INSERT INTO `cities` VALUES ('130', '360400', '九江市', '360000'); 
    INSERT INTO `cities` VALUES ('131', '360500', '新余市', '360000'); 
    INSERT INTO `cities` VALUES ('132', '360600', '鹰潭市', '360000'); 
    INSERT INTO `cities` VALUES ('133', '360700', '赣州市', '360000'); 
    INSERT INTO `cities` VALUES ('134', '360800', '吉安市', '360000'); 
    INSERT INTO `cities` VALUES ('135', '360900', '宜春市', '360000'); 
    INSERT INTO `cities` VALUES ('136', '361000', '抚州市', '360000'); 
    INSERT INTO `cities` VALUES ('137', '361100', '上饶市', '360000'); 
    INSERT INTO `cities` VALUES ('138', '370100', '济南市', '370000'); 
    INSERT INTO `cities` VALUES ('139', '370200', '青岛市', '370000'); 
    INSERT INTO `cities` VALUES ('140', '370300', '淄博市', '370000'); 
    INSERT INTO `cities` VALUES ('141', '370400', '枣庄市', '370000'); 
    INSERT INTO `cities` VALUES ('142', '370500', '东营市', '370000'); 
    INSERT INTO `cities` VALUES ('143', '370600', '烟台市', '370000'); 
    INSERT INTO `cities` VALUES ('144', '370700', '潍坊市', '370000'); 
    INSERT INTO `cities` VALUES ('145', '370800', '济宁市', '370000'); 
    INSERT INTO `cities` VALUES ('146', '370900', '泰安市', '370000'); 
    INSERT INTO `cities` VALUES ('147', '371000', '威海市', '370000'); 
    INSERT INTO `cities` VALUES ('148', '371100', '日照市', '370000'); 
    INSERT INTO `cities` VALUES ('149', '371200', '莱芜市', '370000'); 
    INSERT INTO `cities` VALUES ('150', '371300', '临沂市', '370000'); 
    INSERT INTO `cities` VALUES ('151', '371400', '德州市', '370000'); 
    INSERT INTO `cities` VALUES ('152', '371500', '聊城市', '370000'); 
    INSERT INTO `cities` VALUES ('153', '371600', '滨州市', '370000'); 
    INSERT INTO `cities` VALUES ('154', '371700', '荷泽市', '370000'); 
    INSERT INTO `cities` VALUES ('155', '410100', '郑州市', '410000'); 
    INSERT INTO `cities` VALUES ('156', '410200', '开封市', '410000'); 
    INSERT INTO `cities` VALUES ('157', '410300', '洛阳市', '410000'); 
    INSERT INTO `cities` VALUES ('158', '410400', '平顶山市', '410000'); 
    INSERT INTO `cities` VALUES ('159', '410500', '安阳市', '410000'); 
    INSERT INTO `cities` VALUES ('160', '410600', '鹤壁市', '410000'); 
    INSERT INTO `cities` VALUES ('161', '410700', '新乡市', '410000'); 
    INSERT INTO `cities` VALUES ('162', '410800', '焦作市', '410000'); 
    INSERT INTO `cities` VALUES ('163', '410900', '濮阳市', '410000'); 
    INSERT INTO `cities` VALUES ('164', '411000', '许昌市', '410000'); 
    INSERT INTO `cities` VALUES ('165', '411100', '漯河市', '410000'); 
    INSERT INTO `cities` VALUES ('166', '411200', '三门峡市', '410000'); 
    INSERT INTO `cities` VALUES ('167', '411300', '南阳市', '410000'); 
    INSERT INTO `cities` VALUES ('168', '411400', '商丘市', '410000'); 
    INSERT INTO `cities` VALUES ('169', '411500', '信阳市', '410000'); 
    INSERT INTO `cities` VALUES ('170', '411600', '周口市', '410000'); 
    INSERT INTO `cities` VALUES ('171', '411700', '驻马店市', '410000'); 
    INSERT INTO `cities` VALUES ('172', '420100', '武汉市', '420000'); 
    INSERT INTO `cities` VALUES ('173', '420200', '黄石市', '420000'); 
    INSERT INTO `cities` VALUES ('174', '420300', '十堰市', '420000'); 
    INSERT INTO `cities` VALUES ('175', '420500', '宜昌市', '420000'); 
    INSERT INTO `cities` VALUES ('176', '420600', '襄樊市', '420000'); 
    INSERT INTO `cities` VALUES ('177', '420700', '鄂州市', '420000'); 
    INSERT INTO `cities` VALUES ('178', '420800', '荆门市', '420000'); 
    INSERT INTO `cities` VALUES ('179', '420900', '孝感市', '420000'); 
    INSERT INTO `cities` VALUES ('180', '421000', '荆州市', '420000'); 
    INSERT INTO `cities` VALUES ('181', '421100', '黄冈市', '420000'); 
    INSERT INTO `cities` VALUES ('182', '421200', '咸宁市', '420000'); 
    INSERT INTO `cities` VALUES ('183', '421300', '随州市', '420000'); 
    INSERT INTO `cities` VALUES ('184', '422800', '恩施土家族苗族自治州', '420000'); 
    INSERT INTO `cities` VALUES ('185', '429000', '省直辖行政单位', '420000'); 
    INSERT INTO `cities` VALUES ('186', '430100', '长沙市', '430000'); 
    INSERT INTO `cities` VALUES ('187', '430200', '株洲市', '430000'); 
    INSERT INTO `cities` VALUES ('188', '430300', '湘潭市', '430000'); 
    INSERT INTO `cities` VALUES ('189', '430400', '衡阳市', '430000'); 
    INSERT INTO `cities` VALUES ('190', '430500', '邵阳市', '430000'); 
    INSERT INTO `cities` VALUES ('191', '430600', '岳阳市', '430000'); 
    INSERT INTO `cities` VALUES ('192', '430700', '常德市', '430000'); 
    INSERT INTO `cities` VALUES ('193', '430800', '张家界市', '430000'); 
    INSERT INTO `cities` VALUES ('194', '430900', '益阳市', '430000'); 
    INSERT INTO `cities` VALUES ('195', '431000', '郴州市', '430000'); 
    INSERT INTO `cities` VALUES ('196', '431100', '永州市', '430000'); 
    INSERT INTO `cities` VALUES ('197', '431200', '怀化市', '430000'); 
    INSERT INTO `cities` VALUES ('198', '431300', '娄底市', '430000'); 
    INSERT INTO `cities` VALUES ('199', '433100', '湘西土家族苗族自治州', '430000'); 
    INSERT INTO `cities` VALUES ('200', '440100', '广州市', '440000'); 
    INSERT INTO `cities` VALUES ('201', '440200', '韶关市', '440000'); 
    INSERT INTO `cities` VALUES ('202', '440300', '深圳市', '440000'); 
    INSERT INTO `cities` VALUES ('203', '440400', '珠海市', '440000'); 
    INSERT INTO `cities` VALUES ('204', '440500', '汕头市', '440000'); 
    INSERT INTO `cities` VALUES ('205', '440600', '佛山市', '440000'); 
    INSERT INTO `cities` VALUES ('206', '440700', '江门市', '440000'); 
    INSERT INTO `cities` VALUES ('207', '440800', '湛江市', '440000'); 
    INSERT INTO `cities` VALUES ('208', '440900', '茂名市', '440000'); 
    INSERT INTO `cities` VALUES ('209', '441200', '肇庆市', '440000'); 
    INSERT INTO `cities` VALUES ('210', '441300', '惠州市', '440000'); 
    INSERT INTO `cities` VALUES ('211', '441400', '梅州市', '440000'); 
    INSERT INTO `cities` VALUES ('212', '441500', '汕尾市', '440000'); 
    INSERT INTO `cities` VALUES ('213', '441600', '河源市', '440000'); 
    INSERT INTO `cities` VALUES ('214', '441700', '阳江市', '440000'); 
    INSERT INTO `cities` VALUES ('215', '441800', '清远市', '440000'); 
    INSERT INTO `cities` VALUES ('216', '441900', '东莞市', '440000'); 
    INSERT INTO `cities` VALUES ('217', '442000', '中山市', '440000'); 
    INSERT INTO `cities` VALUES ('218', '445100', '潮州市', '440000'); 
    INSERT INTO `cities` VALUES ('219', '445200', '揭阳市', '440000'); 
    INSERT INTO `cities` VALUES ('220', '445300', '云浮市', '440000'); 
    INSERT INTO `cities` VALUES ('221', '450100', '南宁市', '450000'); 
    INSERT INTO `cities` VALUES ('222', '450200', '柳州市', '450000'); 
    INSERT INTO `cities` VALUES ('223', '450300', '桂林市', '450000'); 
    INSERT INTO `cities` VALUES ('224', '450400', '梧州市', '450000'); 
    INSERT INTO `cities` VALUES ('225', '450500', '北海市', '450000'); 
    INSERT INTO `cities` VALUES ('226', '450600', '防城港市', '450000'); 
    INSERT INTO `cities` VALUES ('227', '450700', '钦州市', '450000'); 
    INSERT INTO `cities` VALUES ('228', '450800', '贵港市', '450000'); 
    INSERT INTO `cities` VALUES ('229', '450900', '玉林市', '450000'); 
    INSERT INTO `cities` VALUES ('230', '451000', '百色市', '450000'); 
    INSERT INTO `cities` VALUES ('231', '451100', '贺州市', '450000'); 
    INSERT INTO `cities` VALUES ('232', '451200', '河池市', '450000'); 
    INSERT INTO `cities` VALUES ('233', '451300', '来宾市', '450000'); 
    INSERT INTO `cities` VALUES ('234', '451400', '崇左市', '450000'); 
    INSERT INTO `cities` VALUES ('235', '460100', '海口市', '460000'); 
    INSERT INTO `cities` VALUES ('236', '460200', '三亚市', '460000'); 
    INSERT INTO `cities` VALUES ('237', '469000', '省直辖县级行政单位', '460000'); 
    INSERT INTO `cities` VALUES ('238', '500100', '重庆市', '500000'); 
    INSERT INTO `cities` VALUES ('239', '5002xx', '重庆下属县', '5000xx'); 
    INSERT INTO `cities` VALUES ('240', '5003xx', '重庆下属市', '5000xx'); 
    INSERT INTO `cities` VALUES ('241', '510100', '成都市', '510000'); 
    INSERT INTO `cities` VALUES ('242', '510300', '自贡市', '510000'); 
    INSERT INTO `cities` VALUES ('243', '510400', '攀枝花市', '510000'); 
    INSERT INTO `cities` VALUES ('244', '510500', '泸州市', '510000'); 
    INSERT INTO `cities` VALUES ('245', '510600', '德阳市', '510000'); 
    INSERT INTO `cities` VALUES ('246', '510700', '绵阳市', '510000'); 
    INSERT INTO `cities` VALUES ('247', '510800', '广元市', '510000'); 
    INSERT INTO `cities` VALUES ('248', '510900', '遂宁市', '510000'); 
    INSERT INTO `cities` VALUES ('249', '511000', '内江市', '510000'); 
    INSERT INTO `cities` VALUES ('250', '511100', '乐山市', '510000'); 
    INSERT INTO `cities` VALUES ('251', '511300', '南充市', '510000'); 
    INSERT INTO `cities` VALUES ('252', '511400', '眉山市', '510000'); 
    INSERT INTO `cities` VALUES ('253', '511500', '宜宾市', '510000'); 
    INSERT INTO `cities` VALUES ('254', '511600', '广安市', '510000'); 
    INSERT INTO `cities` VALUES ('255', '511700', '达州市', '510000'); 
    INSERT INTO `cities` VALUES ('256', '511800', '雅安市', '510000'); 
    INSERT INTO `cities` VALUES ('257', '511900', '巴中市', '510000'); 
    INSERT INTO `cities` VALUES ('258', '512000', '资阳市', '510000'); 
    INSERT INTO `cities` VALUES ('259', '513200', '阿坝藏族羌族自治州', '510000'); 
    INSERT INTO `cities` VALUES ('260', '513300', '甘孜藏族自治州', '510000'); 
    INSERT INTO `cities` VALUES ('261', '513400', '凉山彝族自治州', '510000'); 
    INSERT INTO `cities` VALUES ('262', '520100', '贵阳市', '520000'); 
    INSERT INTO `cities` VALUES ('263', '520200', '六盘水市', '520000'); 
    INSERT INTO `cities` VALUES ('264', '520300', '遵义市', '520000'); 
    INSERT INTO `cities` VALUES ('265', '520400', '安顺市', '520000'); 
    INSERT INTO `cities` VALUES ('266', '522200', '铜仁地区', '520000'); 
    INSERT INTO `cities` VALUES ('267', '522300', '黔西南布依族苗族自治州', '520000'); 
    INSERT INTO `cities` VALUES ('268', '522400', '毕节地区', '520000'); 
    INSERT INTO `cities` VALUES ('269', '522600', '黔东南苗族侗族自治州', '520000'); 
    INSERT INTO `cities` VALUES ('270', '522700', '黔南布依族苗族自治州', '520000'); 
    INSERT INTO `cities` VALUES ('271', '530100', '昆明市', '530000'); 
    INSERT INTO `cities` VALUES ('272', '530300', '曲靖市', '530000'); 
    INSERT INTO `cities` VALUES ('273', '530400', '玉溪市', '530000'); 
    INSERT INTO `cities` VALUES ('274', '530500', '保山市', '530000'); 
    INSERT INTO `cities` VALUES ('275', '530600', '昭通市', '530000'); 
    INSERT INTO `cities` VALUES ('276', '530700', '丽江市', '530000'); 
    INSERT INTO `cities` VALUES ('277', '530800', '思茅市', '530000'); 
    INSERT INTO `cities` VALUES ('278', '530900', '临沧市', '530000'); 
    INSERT INTO `cities` VALUES ('279', '532300', '楚雄彝族自治州', '530000'); 
    INSERT INTO `cities` VALUES ('280', '532500', '红河哈尼族彝族自治州', '530000'); 
    INSERT INTO `cities` VALUES ('281', '532600', '文山壮族苗族自治州', '530000'); 
    INSERT INTO `cities` VALUES ('282', '532800', '西双版纳傣族自治州', '530000'); 
    INSERT INTO `cities` VALUES ('283', '532900', '大理白族自治州', '530000'); 
    INSERT INTO `cities` VALUES ('284', '533100', '德宏傣族景颇族自治州', '530000'); 
    INSERT INTO `cities` VALUES ('285', '533300', '怒江傈僳族自治州', '530000'); 
    INSERT INTO `cities` VALUES ('286', '533400', '迪庆藏族自治州', '530000'); 
    INSERT INTO `cities` VALUES ('287', '540100', '拉萨市', '540000'); 
    INSERT INTO `cities` VALUES ('288', '542100', '昌都地区', '540000'); 
    INSERT INTO `cities` VALUES ('289', '542200', '山南地区', '540000'); 
    INSERT INTO `cities` VALUES ('290', '542300', '日喀则地区', '540000'); 
    INSERT INTO `cities` VALUES ('291', '542400', '那曲地区', '540000'); 
    INSERT INTO `cities` VALUES ('292', '542500', '阿里地区', '540000'); 
    INSERT INTO `cities` VALUES ('293', '542600', '林芝地区', '540000'); 
    INSERT INTO `cities` VALUES ('294', '610100', '西安市', '610000'); 
    INSERT INTO `cities` VALUES ('295', '610200', '铜川市', '610000'); 
    INSERT INTO `cities` VALUES ('296', '610300', '宝鸡市', '610000'); 
    INSERT INTO `cities` VALUES ('297', '610400', '咸阳市', '610000'); 
    INSERT INTO `cities` VALUES ('298', '610500', '渭南市', '610000'); 
    INSERT INTO `cities` VALUES ('299', '610600', '延安市', '610000'); 
    INSERT INTO `cities` VALUES ('300', '610700', '汉中市', '610000'); 
    INSERT INTO `cities` VALUES ('301', '610800', '榆林市', '610000'); 
    INSERT INTO `cities` VALUES ('302', '610900', '安康市', '610000'); 
    INSERT INTO `cities` VALUES ('303', '611000', '商洛市', '610000'); 
    INSERT INTO `cities` VALUES ('304', '620100', '兰州市', '620000'); 
    INSERT INTO `cities` VALUES ('305', '620200', '嘉峪关市', '620000'); 
    INSERT INTO `cities` VALUES ('306', '620300', '金昌市', '620000'); 
    INSERT INTO `cities` VALUES ('307', '620400', '白银市', '620000'); 
    INSERT INTO `cities` VALUES ('308', '620500', '天水市', '620000'); 
    INSERT INTO `cities` VALUES ('309', '620600', '武威市', '620000'); 
    INSERT INTO `cities` VALUES ('310', '620700', '张掖市', '620000'); 
    INSERT INTO `cities` VALUES ('311', '620800', '平凉市', '620000'); 
    INSERT INTO `cities` VALUES ('312', '620900', '酒泉市', '620000'); 
    INSERT INTO `cities` VALUES ('313', '621000', '庆阳市', '620000'); 
    INSERT INTO `cities` VALUES ('314', '621100', '定西市', '620000'); 
    INSERT INTO `cities` VALUES ('315', '621200', '陇南市', '620000'); 
    INSERT INTO `cities` VALUES ('316', '622900', '临夏回族自治州', '620000'); 
    INSERT INTO `cities` VALUES ('317', '623000', '甘南藏族自治州', '620000'); 
    INSERT INTO `cities` VALUES ('318', '630100', '西宁市', '630000'); 
    INSERT INTO `cities` VALUES ('319', '632100', '海东地区', '630000'); 
    INSERT INTO `cities` VALUES ('320', '632200', '海北藏族自治州', '630000'); 
    INSERT INTO `cities` VALUES ('321', '632300', '黄南藏族自治州', '630000'); 
    INSERT INTO `cities` VALUES ('322', '632500', '海南藏族自治州', '630000'); 
    INSERT INTO `cities` VALUES ('323', '632600', '果洛藏族自治州', '630000'); 
    INSERT INTO `cities` VALUES ('324', '632700', '玉树藏族自治州', '630000'); 
    INSERT INTO `cities` VALUES ('325', '632800', '海西蒙古族藏族自治州', '630000'); 
    INSERT INTO `cities` VALUES ('326', '640100', '银川市', '640000'); 
    INSERT INTO `cities` VALUES ('327', '640200', '石嘴山市', '640000'); 
    INSERT INTO `cities` VALUES ('328', '640300', '吴忠市', '640000'); 
    INSERT INTO `cities` VALUES ('329', '640400', '固原市', '640000'); 
    INSERT INTO `cities` VALUES ('330', '640500', '中卫市', '640000'); 
    INSERT INTO `cities` VALUES ('331', '650100', '乌鲁木齐市', '650000'); 
    INSERT INTO `cities` VALUES ('332', '650200', '克拉玛依市', '650000'); 
    INSERT INTO `cities` VALUES ('333', '652100', '吐鲁番地区', '650000'); 
    INSERT INTO `cities` VALUES ('334', '652200', '哈密地区', '650000'); 
    INSERT INTO `cities` VALUES ('335', '652300', '昌吉回族自治州', '650000'); 
    INSERT INTO `cities` VALUES ('336', '652700', '博尔塔拉蒙古自治州', '650000'); 
    INSERT INTO `cities` VALUES ('337', '652800', '巴音郭楞蒙古自治州', '650000'); 
    INSERT INTO `cities` VALUES ('338', '652900', '阿克苏地区', '650000'); 
    INSERT INTO `cities` VALUES ('339', '653000', '克孜勒苏柯尔克孜自治州', '650000'); 
    INSERT INTO `cities` VALUES ('340', '653100', '喀什地区', '650000'); 
    INSERT INTO `cities` VALUES ('341', '653200', '和田地区', '650000'); 
    INSERT INTO `cities` VALUES ('342', '654000', '伊犁哈萨克自治州', '650000'); 
    INSERT INTO `cities` VALUES ('343', '654200', '塔城地区', '650000'); 
    INSERT INTO `cities` VALUES ('344', '654300', '阿勒泰地区', '650000'); 
    INSERT INTO `cities` VALUES ('345', '659000', '省直辖行政单位', '650000');

    因sql语句太长,区的表数据添加请查看下一篇博客

    mysql省市区三级联动数据库的源码(二)

    展开全文
  • 省市区三级联动数据库资源,
  • 页面导入js,直接调用cascade(0,0,0)即可,修改时请传入省市区的id或名称,即可默认选中 需要的朋友,请自行创建数据库
  • 省市区三级联动——自关联——数据
  • 省市区 区域联动数据库文件, 经纬度,邮政编码 区号 拼音 等
  • 本来是想免费的但是最低就是一分,相信大家也不在乎这一分,里面是一个中国省市三级联动的SQL语句,字段包括 id , name , parentid ,使用方法大概介绍下,首先省的parentid 都为0,省那一栏查询所有parentid为0的...
  • 把下载包里面的sql文件加载到数据库之后,在php链接数据库的时候更换下数据库密码就可以用了!方便的很,楼主自己在用!
  • 中国省市三级联动数据库MYSQL格式。
  • 前端 省市区三级联动 json数据 已经经过测试 可以放心使用
  • 内含所有省市区的地区编码和地区名,里面为sql文件直接运行即可。
  • 全国地区所有的省、市、(县)三级联动数据库信息。
  • 省市三级联动数据库,文件是导出的SQL语句,下载后直接执行即可。
  • //页面部分代码 丢失地点  省 Input  市   .../县 //js代码 $(document).ready(function(){ $.ajax({  type: "post",  dataType: "json",  

    //页面部分代码

    <div class="mui-input-row">
    <label class="txt2">丢失地点</label> 
    <!-- 用于保存省份的name -->
    <input type="hidden" id="liveProvinceBaseName" name="  ">
    <select class="mui-inline mui-select" id="province" name="  " >
    <option>省</option>
    </select>
    </div>
    <div class="mui-input-row">
    <label style="display: none;">Input</label>
    <!-- 用于保存市区的name -->
    <input type="hidden" id="liveCityBaseName" name="  ">
    <select class="mui-inline mui-select" id="city" name="  ">
          <option>市</option>
     
    </select>
    </div>
    <div class="mui-input-row">
    <label style="display: none;">Input</label> 
    <!-- 用于保存区县的name -->
    <input type="hidden" id="liveDowntownBaseName" name=" ">
    <select class="mui-inline mui-select" id="county" name=" ">
    <option>区/县</option>
    </select>
    </div>


    //js代码

    $(document).ready(function(){


    $.ajax({
            type: "post",
            dataType: "json",
            url: "  ",
            success: function(data){

          var result = "<option>选择省份</option>"
          $.each(data, function(i, item) {
          result +="<option value='"+item.proId+"'>"+item.proName+"</option>";
          });
          $("#province").html('');
            $("#province").append(result);
            }
        });


    $("#province").change(function () {
    var selectedIndex = document.getElementById("province").selectedIndex;
    $("#liveProvinceBaseName").val(document.getElementById("province").options[selectedIndex].text);
      $.ajax({
               type: "post",
               dataType: "json",
               url: "  ",
               data: {provinceid:$("#province").val()},
               success: function(data){

              var result = "<option>选择城市</option>"
              $.each(data, function(i, item) {
              result +="<option value='"+item.cityId+"'>"+item.cityName+"</option>";
              });
              $("#city").html(' ');
                $("#city").append(result);
                
                var result1 = "<option>选择区域</option>";
                $("#county").html(' ');
                $("#county").append(result1);
               }
           });
      });
      
      
      $("#city").change(function () {
    var selectedIndex = document.getElementById("city").selectedIndex;
    $("#liveCityBaseName").val(document.getElementById("city").options[selectedIndex].text);

      $.ajax({
              type: "get",
              dataType:"json",
              url: " ",
              data: {cityid:$("#city").val()},
              success: function(data){

              var result = "<option>选择区域</option>";
              $.each(data, function(i, item) {
              result +="<option value='"+item.dtId+"'>"+item.downtownName+"</option>";
              });
              $("#county").html('');
              $("#county").append(result);
              }
          });
        });
      
      $("#county").change(function () {
    var selectedIndex = document.getElementById("county").selectedIndex;
    $("#liveDowntownBaseName").val(document.getElementById("county").options[selectedIndex].text);
      });
      
    });
    展开全文

空空如也

空空如也

1 2 3 4 5 ... 20
收藏数 1,635
精华内容 654
关键字:

省市区三级联动数据库