全国省市数据MYSQL - 省市

于 2024-04-16 15:56:05 发布
阅读量106 收藏
点赞数 1
文章标签： mysql android 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/johnlee0722/article/details/137823089
版权 
CREATE TABLE `region` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `code` varchar(10) NOT NULL COMMENT '行政区划编码',
  `name` varchar(50) NOT NULL COMMENT '行政区划名称',
  `parent_code` varchar(10) DEFAULT NULL COMMENT '父级行政区划编码',
  `create_by` varchar(64) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '更新人',
  `update_by` varchar(64) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '修改人',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_code` (`code`) USING BTREE,
  KEY `idx_parent_code` (`parent_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=388 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='行政区划表';

添加全国

INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('100000', '全国', NULL,'sys','sys',NOW(),NOW());

添加省/直辖市

INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('110000', '北京市', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('120000', '天津市', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('130000', '河北省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('140000', '山西省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('150000', '内蒙古自治区', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('210000', '辽宁省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('220000', '吉林省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('230000', '黑龙江省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('310000', '上海市', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('320000', '江苏省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('330000', '浙江省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('340000', '安徽省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('350000', '福建省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('360000', '江西省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('370000', '山东省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('410000', '河南省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('420000', '湖北省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('430000', '湖南省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('440000', '广东省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('450000', '广西壮族自治区', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('460000', '海南省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('500000', '重庆市', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('510000', '四川省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('520000', '贵州省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('530000', '云南省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('540000', '西藏自治区', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('610000', '陕西省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('620000', '甘肃省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('630000', '青海省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('640000', '宁夏回族自治区', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('650000', '新疆维吾尔自治区', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('710000', '台湾省', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('810000', '香港特别行政区', '100000','sys','sys',NOW(),NOW());
INSERT INTO `region` (`code`, `name`, `parent_code`, create_by, update_by, create_time, update_time) VALUES ('820000', '澳门特别行政区', '100000','sys','sys',NOW(),NOW());

添加城市

insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('110101','东城区','110000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('110102','西城区','110000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('110105','朝阳区','110000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('110106','丰台区','110000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('110107','石景山区','110000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('110108','海淀区','110000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('110109','门头沟区','110000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('110111','房山区','110000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('110112','通州区','110000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('110113','顺义区','110000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('110114','昌平区','110000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('110115','大兴区','110000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('110116','怀柔区','110000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('110117','平谷区','110000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('110118','密云区','110000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('110119','延庆区','110000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('120101','和平区','120000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('120102','河东区','120000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('120103','河西区','120000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('120104','南开区','120000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('120105','河北区','120000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('120106','红桥区','120000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('120110','东丽区','120000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('120111','西青区','120000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('120112','津南区','120000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('120113','北辰区','120000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('120114','武清区','120000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('120115','宝坻区','120000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('120116','滨海新区','120000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('120117','宁河区','120000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('120118','静海区','120000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('120119','蓟州区','120000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('130100','石家庄市','130000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('130200','唐山市','130000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('130300','秦皇岛市','130000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('130400','邯郸市','130000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('130500','邢台市','130000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('130600','保定市','130000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('130700','张家口市','130000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('130800','承德市','130000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('130900','沧州市','130000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('131000','廊坊市','130000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('131100','衡水市','130000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('140100','太原市','140000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('140200','大同市','140000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('140300','阳泉市','140000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('140400','长治市','140000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('140500','晋城市','140000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('140600','朔州市','140000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('140700','晋中市','140000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('140800','运城市','140000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('140900','忻州市','140000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('141000','临汾市','140000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('141100','吕梁市','140000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('150100','呼和浩特市','150000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('150200','包头市','150000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('150300','乌海市','150000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('150400','赤峰市','150000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('150500','通辽市','150000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('150600','鄂尔多斯市','150000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('150700','呼伦贝尔市','150000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('150800','巴彦淖尔市','150000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('150900','乌兰察布市','150000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('152200','兴安盟','150000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('152500','锡林郭勒盟','150000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('152900','阿拉善盟','150000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('210100','沈阳市','210000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('210200','大连市','210000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('210300','鞍山市','210000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('210400','抚顺市','210000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('210500','本溪市','210000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('210600','丹东市','210000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('210700','锦州市','210000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('210800','营口市','210000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('210900','阜新市','210000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('211000','辽阳市','210000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('211100','盘锦市','210000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('211200','铁岭市','210000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('211300','朝阳市','210000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('211400','葫芦岛市','210000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('220100','长春市','220000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('220200','吉林市','220000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('220300','四平市','220000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('220400','辽源市','220000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('220500','通化市','220000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('220600','白山市','220000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('220700','松原市','220000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('220800','白城市','220000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('222400','延边朝鲜族自治州','220000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('230100','哈尔滨市','230000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('230200','齐齐哈尔市','230000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('230300','鸡西市','230000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('230400','鹤岗市','230000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('230500','双鸭山市','230000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('230600','大庆市','230000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('230700','伊春市','230000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('230800','佳木斯市','230000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('230900','七台河市','230000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('231000','牡丹江市','230000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('231100','黑河市','230000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('231200','绥化市','230000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('232700','大兴安岭地区','230000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('310101','黄浦区','310000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('310104','徐汇区','310000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('310105','长宁区','310000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('310106','静安区','310000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('310107','普陀区','310000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('310109','虹口区','310000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('310110','杨浦区','310000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('310112','闵行区','310000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('310113','宝山区','310000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('310114','嘉定区','310000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('310115','浦东新区','310000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('310116','金山区','310000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('310117','松江区','310000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('310118','青浦区','310000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('310120','奉贤区','310000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('310151','崇明区','310000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('320100','南京市','320000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('320200','无锡市','320000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('320300','徐州市','320000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('320400','常州市','320000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('320500','苏州市','320000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('320600','南通市','320000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('320700','连云港市','320000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('320800','淮安市','320000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('320900','盐城市','320000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('321000','扬州市','320000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('321100','镇江市','320000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('321200','泰州市','320000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('321300','宿迁市','320000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('330100','杭州市','330000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('330200','宁波市','330000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('330300','温州市','330000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('330400','嘉兴市','330000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('330500','湖州市','330000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('330600','绍兴市','330000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('330700','金华市','330000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('330800','衢州市','330000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('330900','舟山市','330000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('331000','台州市','330000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('331100','丽水市','330000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('340100','合肥市','340000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('340200','芜湖市','340000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('340300','蚌埠市','340000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('340400','淮南市','340000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('340500','马鞍山市','340000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('340600','淮北市','340000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('340700','铜陵市','340000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('340800','安庆市','340000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('341000','黄山市','340000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('341100','滁州市','340000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('341200','阜阳市','340000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('341300','宿州市','340000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('341400','巢湖市','340000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('341500','六安市','340000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('341600','亳州市','340000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('341700','池州市','340000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('341800','宣城市','340000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('350100','福州市','350000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('350200','厦门市','350000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('350300','莆田市','350000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('350400','三明市','350000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('350500','泉州市','350000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('350600','漳州市','350000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('350700','南平市','350000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('350800','龙岩市','350000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('350900','宁德市','350000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('360100','南昌市','360000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('360200','景德镇市','360000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('360300','萍乡市','360000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('360400','九江市','360000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('360500','新余市','360000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('360600','鹰潭市','360000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('360700','赣州市','360000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('360800','吉安市','360000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('360900','宜春市','360000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('361000','抚州市','360000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('361100','上饶市','360000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('370100','济南市','370000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('370200','青岛市','370000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('370300','淄博市','370000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('370400','枣庄市','370000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('370500','东营市','370000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('370600','烟台市','370000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('370700','潍坊市','370000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('370800','济宁市','370000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('370900','泰安市','370000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('371000','威海市','370000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('371100','日照市','370000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('371200','莱芜市','370000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('371300','临沂市','370000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('371400','德州市','370000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('371500','聊城市','370000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('371600','滨州市','370000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('371700','荷泽市','370000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('410100','郑州市','410000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('410200','开封市','410000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('410300','洛阳市','410000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('410400','平顶山市','410000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('410500','安阳市','410000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('410600','鹤壁市','410000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('410700','新乡市','410000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('410800','焦作市','410000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('410900','濮阳市','410000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('411000','许昌市','410000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('411100','漯河市','410000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('411200','三门峡市','410000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('411300','南阳市','410000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('411400','商丘市','410000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('411500','信阳市','410000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('411600','周口市','410000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('411700','驻马店市','410000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('420100','武汉市','420000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('420200','黄石市','420000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('420300','十堰市','420000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('420500','宜昌市','420000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('420600','襄樊市','420000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('420700','鄂州市','420000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('420800','荆门市','420000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('420900','孝感市','420000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('421000','荆州市','420000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('421100','黄冈市','420000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('421200','咸宁市','420000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('421300','随州市','420000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('422800','恩施土家族苗族自治州','420000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('429004','仙桃市','420000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('429005','潜江市','420000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('429006','天门市','420000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('429021','神农架林区','420000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('430100','长沙市','430000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('430200','株洲市','430000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('430300','湘潭市','430000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('430400','衡阳市','430000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('430500','邵阳市','430000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('430600','岳阳市','430000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('430700','常德市','430000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('430800','张家界市','430000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('430900','益阳市','430000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('431000','郴州市','430000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('431100','永州市','430000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('431200','怀化市','430000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('431300','娄底市','430000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('433100','湘西土家族苗族自治州','430000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('440100','广州市','440000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('440200','韶关市','440000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('440300','深圳市','440000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('440400','珠海市','440000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('440500','汕头市','440000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('440600','佛山市','440000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('440700','江门市','440000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('440800','湛江市','440000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('440900','茂名市','440000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('441200','肇庆市','440000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('441300','惠州市','440000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('441400','梅州市','440000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('441500','汕尾市','440000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('441600','河源市','440000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('441700','阳江市','440000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('441800','清远市','440000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('441900','东莞市','440000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('442000','中山市','440000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('445100','潮州市','440000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('445200','揭阳市','440000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('445300','云浮市','440000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('450100','南宁市','450000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('450200','柳州市','450000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('450300','桂林市','450000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('450400','梧州市','450000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('450500','北海市','450000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('450600','防城港市','450000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('450700','钦州市','450000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('450800','贵港市','450000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('450900','玉林市','450000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('451000','百色市','450000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('451100','贺州市','450000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('451200','河池市','450000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('451300','来宾市','450000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('451400','崇左市','450000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('460100','海口市','460000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('460200','三亚市','460000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('460300','三沙市','460000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('460400','儋州市','460000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('510100','成都市','510000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('510300','自贡市','510000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('510400','攀枝花市','510000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('510500','泸州市','510000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('510600','德阳市','510000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('510700','绵阳市','510000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('510800','广元市','510000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('510900','遂宁市','510000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('511000','内江市','510000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('511100','乐山市','510000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('511300','南充市','510000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('511400','眉山市','510000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('511500','宜宾市','510000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('511600','广安市','510000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('511700','达州市','510000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('511800','雅安市','510000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('511900','巴中市','510000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('512000','资阳市','510000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('513200','阿坝藏族羌族自治州','510000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('513300','甘孜藏族自治州','510000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('513400','凉山彝族自治州','510000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('520100','贵阳市','520000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('520200','六盘水市','520000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('520300','遵义市','520000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('520400','安顺市','520000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('520500','毕节市','520000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('520600','铜仁市','520000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('522300','黔西南布依族苗族自治州','520000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('522600','黔东南苗族侗族自治州','520000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('522700','黔南布依族苗族自治州','520000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('530100','昆明市','530000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('530300','曲靖市','530000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('530400','玉溪市','530000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('530500','保山市','530000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('530600','昭通市','530000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('530700','丽江市','530000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('530800','思茅市','530000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('530900','临沧市','530000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('532300','楚雄彝族自治州','530000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('532500','红河哈尼族彝族自治州','530000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('532600','文山壮族苗族自治州','530000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('532800','西双版纳傣族自治州','530000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('532900','大理白族自治州','530000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('533100','德宏傣族景颇族自治州','530000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('533300','怒江傈僳族自治州','530000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('533400','迪庆藏族自治州','530000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('540100','拉萨市','540000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('540200','日喀则市','540000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('540300','昌都市','540000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('540400','林芝市','540000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('540500','山南市','540000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('540600','那曲市','540000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('542500','阿里地区','540000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('610100','西安市','610000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('610200','铜川市','610000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('610300','宝鸡市','610000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('610400','咸阳市','610000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('610500','渭南市','610000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('610600','延安市','610000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('610700','汉中市','610000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('610800','榆林市','610000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('610900','安康市','610000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('611000','商洛市','610000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('620100','兰州市','620000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('620200','嘉峪关市','620000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('620300','金昌市','620000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('620400','白银市','620000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('620500','天水市','620000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('620600','武威市','620000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('620700','张掖市','620000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('620800','平凉市','620000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('620900','酒泉市','620000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('621000','庆阳市','620000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('621100','定西市','620000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('621200','陇南市','620000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('622900','临夏回族自治州','620000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('623000','甘南藏族自治州','620000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('630100','西宁市','630000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('630200','海东市','630000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('632200','海北藏族自治州','630000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('632300','黄南藏族自治州','630000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('632500','海南藏族自治州','630000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('632600','果洛藏族自治州','630000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('632700','玉树藏族自治州','630000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('632800','海西蒙古族藏族自治州','630000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('640100','银川市','640000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('640200','石嘴山市','640000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('640300','吴忠市','640000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('640400','固原市','640000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('640500','中卫市','640000','sys','sys',NOW(),NOW());

    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('650100','乌鲁木齐市','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('650200','克拉玛依市','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('650400','吐鲁番市','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('650500','哈密市','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('652300','昌吉回族自治州','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('652700','博尔塔拉蒙古自治州','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('652800','巴音郭楞蒙古自治州','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('652900','阿克苏地区','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('653000','克孜勒苏柯尔克孜自治州','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('653100','喀什地区','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('653200','和田地区','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('654000','伊犁哈萨克自治州','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('654200','塔城地区','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('654300','阿勒泰地区','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('659001','石河子市','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('659002','阿拉尔市','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('659003','图木舒克市','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('659004','五家渠市','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('659005','北屯市','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('659006','铁门关市','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('659007','双河市','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('659008','可克达拉市','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('659009','昆玉市','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('659010','胡杨河市','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('659011','新星市','650000','sys','sys',NOW(),NOW());
    insert into region(code,`name`,parent_code, create_by, update_by, create_time, update_time) values('659012','白杨市','650000','sys','sys',NOW(),NOW());

丶Frank_Lee
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
最新全国省市区地区（MySQL）数据，附数据文件
12-12
数据为2019年最新数据包。持续更新地址：https://www.yii666.com/share/34.html
2017最新省市区数据表mysql
10-17
PHP + mysql数据表，2017最新省市区资源，即下即用。
MySQL中国省市区数据表
灿的博客
04-04 1573
MySQL中国省市区数据表
MySQL 中国省市区SQL表数据
csdnlaiyanqi的博客
04-21 9539
MySQL 中国省市区SQL表数据 1.查省 SELECT * FROM china WHERE china.Pid=0 /*这里查询的是中国大陆所有的省份，不包括港澳台*/ mysql> SELECT * FROM china WHERE china.Pid=0; +--------+--------------------------+------+ | Id | Name | Pid | +--------+-------------------
最新全国省市区MySQL数据库
11-09
最新全国省市区MySQL数据库，总共4级3792条数据，包含建表语句city(code,parentCode,name,level) 若需全国省、市、区、街道、村镇数据汇总，总共6级72万3738条数据，请移步至 https://download.csdn.net/download/oudoud/10774679
全国最新省市区MYSQL数据文件
06-04
全国省市五级数据，国、省、市、区县、乡镇街道。sql文件，导入即可。
全国省市区 mysql 数据
02-08
全国省市区 mysql 数据
全国省市区MySQL数据表
12-07
全国省市区数据，MySQL数据表，导入数据库可直接使用（含地区编码、地区名称、地区级别、父节点等字段）。
级联数据全国省市区mysql版本
最新发布
05-27
级联数据测试 国内省市区级联 mysql数据库
中国的省市区县mysql数据表
07-06
包含中国的省市区县的mysql表
全国最新省市区mysql地区数据库
05-09
2017年最新最全的全国省市区mysql数据库升级版，49260条，与国家统计局数据同步，采集自淘宝，全国省市区mysql数据库
中国城市数据表（mysql）
07-11
中国城市数据表（mysql）脚本，包括港澳台，身份证前6位代码，城市拼音，首拼音，层级，区号，邮编，经纬度等信息.
中国地级市数据MySQL
01-30
全国地级市sql文件，方便可靠，
中国省份和城市数据(mysql数据库)
06-20
中国城市mysql数据，包括省份、城市。 两个表，一个省份表，一个城市表。
中国所有城市sql
07-18
2017年统计用区划代码和城乡划分代码(截止2017年10月31日) sql语句
中国省/市/县三级联动MySQL数据
热门推荐
【昆山人在上海】
07-15 2万+
-- ---------------------------- -- Table structure for `area` -- ---------------------------- DROP TABLE IF EXISTS `area`; CREATE TABLE `area` ( `id` int(11) NOT NULL AUTO_INCREMENT, `areaID` varc
全国城市列表,全国城市(mysql版)
12-14
Mysql版全国城市列表,下面列出了部分内容： create table `city` ( `id` varchar (60), `name` varchar (60), `pid` varchar (60), `root` char (3), `Zone` int (11) ); insert into `city` (`id`, `name`, `pid`, `root`, `Zone`) values('0001','中国','0000','1','0'); insert into `city` (`id`, `name`, `pid`, `root`, `Zone`) values('11','北京','0001','1','2'); insert into `city` (`id`, `name`, `pid`, `root`, `Zone`) values('1101','北京市辖','11','1','2'); insert into `city` (`id`, `name`, `pid`, `root`, `Zone`) values('110101','东城区','1101','0','2');
最新最全好用的全国城市MYSQL数据表（绝对能用亲测）
11-06
最新最全好用的全国城市MYSQL数据表（绝对能用亲测） 单个表的数据 直接导入可用
全国省市区街道 mysql数据表最新
09-09
全国省市区街道的MySQL数据表最新数据可以通过多种方式获取，以下是其中一种可能的实现方案： 1. 数据库设计： 首先，设计一个名为"region"的数据表，包含以下字段: - id: 主键，唯一标识每个区域的ID - name: 区域名称（省市区名称） - parent_id: 父级区域ID，用于表示省市区之间的层次关系 - type: 区域类型字段，用于区分省市区街道，可以使用枚举值或者整数表示不同的层次关系 2. 数据导入： 从官方提供的全国省市区街道的数据源中获取最新的数据，并将其导入到MySQL数据库中的"region"表中。 可通过CSV文件导入或使用ETL工具将数据从数据源导入到数据库。 3. 数据访问： 通过数据库操作语言（如SQL）进行数据访问，执行SELECT语句可以获取全国省市区街道的最新数据。以下是一些查询示例： - 查询所有省份：SELECT * FROM region WHERE type = 'province' - 查询某个省份下所有城市：SELECT * FROM region WHERE parent_id = [省份ID] - 查询某个城市下所有区县：SELECT * FROM region WHERE parent_id = [城市ID] - 查询某个区县下所有街道：SELECT * FROM region WHERE parent_id = [区县ID] 通过执行以上查询语句，就可以从"region"表中获取全国省市区街道的最新数据。 总之，全国省市区街道的最新数据存储在MySQL数据库的"region"表中，可以通过合适的查询语句从表中提取所需的数据。具体的表结构和数据导入方式可能根据数据源的格式和需求进行调整。

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值