中国全省份及其省区域码(sql)

不夸张怕你不相信

已于 2022-10-18 11:02:08 修改

阅读量1k

点赞数 1

于 2022-10-18 11:01:19 首次发布

本文链接：https://blog.csdn.net/qq_45134562/article/details/127384128

版权

SQL 区域码省份列表前端匹配地域查询

关键词由CSDN通过智能技术生成

中国全省份及其区域码(sql)

作用：按区域匹配的时候给前端这个列表，前端选择之后传回码值，然后根据码值前两位去匹配数据库中地域码的前两位

DROP TABLE IF EXISTS `area`;
CREATE TABLE `area`  (
  `area_code` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '地域码',
  `area_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地域名称',
  PRIMARY KEY (`area_code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

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

SET FOREIGN_KEY_CHECKS = 1;