首先是建表语句
CREATE TABLE `t_address_province` (
`id` INT AUTO_INCREMENT PRIMARY KEY COMMENT '主键',
`code` CHAR(6) NOT NULL COMMENT '省份编码',
`name` VARCHAR(40) NOT NULL COMMENT '省份名称'
) ENGINE=InnoDB DEFAULT CHARSET=UTF8 COMMENT='省份信息表';
CREATE TABLE `t_address_city` (
`id` INT AUTO_INCREMENT PRIMARY KEY COMMENT '主键',
`code` CHAR(6) NOT NULL COMMENT '城市编码',
`name` VARCHAR(40) NOT NULL COMMENT '城市名称',
`provinceCode` CHAR(6) NOT NULL COMMENT '所属省份编码'
) ENGINE=InnoDB DEFAULT CHARSET=UTF8 COMMENT='城市信息表';
CREATE TABLE `t_address_town` (
`id` INT AUTO_INCREMENT PRIMARY KEY COMMENT '主键',
`code` CHAR(6) NOT NULL COMMENT '区县编码',
`name` VARCHAR(40) NOT NULL COMMENT '区县名称',
`cityCode` CHAR(6) NOT NULL COMMENT '所属城市编码'
) ENGINE=InnoDB DEFAULT CHARSET=UTF8 COMMENT='区县信息表';
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
然后是省份信息表数据
INSERT INTO `t_address_province` VALUES ('1', '110000', '北京市');
INSERT INTO `t_address_province` VALUES ('2', '120000', '天津市');
INSERT INTO `t_address_province` VALUES ('3', '130000', '河北省');
INSERT INTO `t_address_province` VALUES ('4', '140000', '山西省');
INSERT INTO `t_address_province` VALUES ('5', '150000', '内蒙古自治区');
INSERT INTO `t_address_province` VALUES ('6', '210000', '辽宁省');
INSERT INTO `t_address_province` VALUES ('7', '220000', '吉林省');
INSERT INTO `t_address_province` VALUES ('8', '230000', '黑龙江省');
INSERT INTO `t_address_province` VALUES ('9', '310000', '上海市');
INSERT INTO `t_address_province` VALUES ('10', '320000', '江苏省');
INSERT INTO `t_address_province` VALUES ('11', '330000', '浙江省');
INSERT INTO `t_address_province` VALUES ('12', '340000', '安徽省');
INSERT INTO `t_address_province` VALUES ('13', '350000', '福建省');
INSERT INTO `t_address_province` VALUES ('14', '360000', '江西省');
INSERT INTO `t_address_province` VALUES ('15', '370000', '山东省');
INSERT INTO `t_address_province` VALUES ('16', '410000', '河南省');
INSERT INTO `t_address_province` VALUES ('17', '420000', '湖北省');
INSERT INTO `t_address_province` VALUES ('18', '430000', '湖南省');
INSERT INTO `t_address_province` VALUES ('19', '440000', '广东省');
INSERT INTO `t_address_province` VALUES ('20', '450000', '广西壮族自治区');
INSERT INTO `t_address_province` VALUES ('21', '460000', '海南省');
INSERT INTO `t_address_province` VALUES ('22', '500000', '重庆市');
INSERT INTO `t_address_province` VALUES ('23', '510000', '四川省');
INSERT INTO `t_address_province` VALUES ('24', '520000', '贵州省');
INSERT INTO `t_address_province` VALUES ('25', '530000', '云南省');
INSERT INTO `t_address_province` VALUES ('26', '540000', '西藏自治区');
INSERT INTO `t_address_province` VALUES ('27', '610000', '陕西省');
INSERT INTO `t_address_province` VALUES ('28', '620000', '甘肃省');
INSERT INTO `t_address_province` VALUES ('29', '630000', '青海省');
INSERT INTO `t_address_province` VALUES ('30', '640000', '宁夏回族自治区');
INSERT INTO `t_address_province` VALUES ('31', '650000', '新疆维吾尔自治区');
INSERT INTO `t_address_province` VALUES ('32', '710000', '台湾省');
INSERT INTO `t_address_province` VALUES ('33', '810000', '香港特别行政区');
INSERT INTO `t_address_province` VALUES ('34', '820000', '澳门特别行政区');
——————————————————————————————————————————————————————————————————————————————————————
INSERT INTO `t_address_city` VALUES ('1', '110100', '北京市', '110000');
INSERT INTO `t_address_city` VALUES ('2', '1102xx', '北京下属县', '1100xx');
INSERT INTO `t_address_city` VALUES ('3', '120100', '天津市', '120000');
INSERT INTO `t_address_city` VALUES ('4', '1202xx', '天津下属县', '1200xx');
INSERT INTO `t_address_city` VALUES ('5', '130100', '石家庄市', '130000');
INSERT INTO `t_address_city` VALUES ('6', '130200', '唐山市', '130000');
INSERT INTO `t_address_city` VALUES ('7', '130300', '秦皇岛市', '130000');
INSERT INTO `t_address_city` VALUES ('8', '130400', '邯郸市', '130000');
INSERT INTO `t_address_city` VALUES ('9', '130500', '邢台市', '130000');
INSERT INTO `t_address_city` VALUES ('10', '130600', '保定市', '130000');
INSERT INTO `t_address_city` VALUES ('11', '130700', '张家口市', '130000');
INSERT INTO `t_address_city` VALUES ('12', '130800', '承德市', '130000');
INSERT INTO `t_address_city` VALUES ('13', '130900', '沧州市', '130000');
INSERT INTO `t_address_city` VALUES ('14', '131000', '廊坊市', '130000');
INSERT INTO `t_address_city` VALUES ('15', '131100', '衡水市', '130000');
INSERT INTO `t_address_city` VALUES ('16', '140100', '太原市', '140000');
INSERT INTO `t_address_city` VALUES ('17', '140200', '大同市', '140000');
INSERT INTO `t_address_city` VALUES ('18', '140300', '阳泉市', '140000');
INSERT INTO `t_address_city` VALUES ('19', '140400', '长治市', '140000');
INSERT INTO `t_address_city` VALUES ('20', '140500', '晋城市', '140000');
INSERT INTO `t_address_city` VALUES ('21', '140600', '朔州市', '140000');
INSERT INTO `t_address_city` VALUES ('22', '140700', '晋中市', '140000');
INSERT INTO `t_address_city` VALUES ('23', '140800', '运城市', '140000');
INSERT INTO `t_address_city` VALUES ('24', '140900', '忻州市', '140000');
INSERT INTO `t_address_city` VALUES ('25', '141000', '临汾市', '140000');
INSERT INTO `t_address_city` VALUES ('26', '141100', '吕梁市', '140000');
INSERT INTO `t_address_city` VALUES ('27', '150100', '呼和浩特市', '150000');
INSERT INTO `t_address_city` VALUES ('28', '150200', '包头市', '150000');
INSERT INTO `t_address_city` VALUES ('29', '150300', '乌海市', '150000');
INSERT INTO `t_address_city` VALUES ('30', '150400', '赤峰市', '150000');
INSERT INTO `t_address_city` VALUES ('31', '150500', '通辽市', '150000');
INSERT INTO `t_address_city` VALUES ('32', '150600', '鄂尔多斯市', '150000');
INSERT INTO `t_address_city` VALUES ('33', '150700', '呼伦贝尔市', '150000');
INSERT INTO `t_address_city` VALUES ('34', '150800', '巴彦淖尔市', '150000');
INSERT INTO `t_address_city` VALUES ('35', '150900', '乌兰察布市', '150000');
INSERT INTO `t_address_city` VALUES ('36', '152200', '兴安盟', '150000');
INSERT INTO `t_address_city` VALUES ('37', '152500', '锡林郭勒盟', '150000');
INSERT INTO `t_address_city` VALUES ('38', '152900', '阿拉善盟', '150000');
INSERT INTO `t_address_city` VALUES ('39', '210100', '沈阳市', '210000');
INSERT INTO `t_address_city` VALUES ('40', '210200', '大连市', '210000');
INSERT INTO `t_address_city` VALUES ('41', '210300', '鞍山市', '210000');
INSERT INTO `t_address_city` VALUES ('42', '210400', '抚顺市', '210000');
INSERT INTO `t_address_city` VALUES ('43', '210500', '本溪市', '210000');
INSERT INTO `t_address_city` VALUES ('44', '210600', '丹东市', '210000');
INSERT INTO `t_address_city` VALUES ('45', '210700', '锦州市', '210000');
INSERT INTO `t_address_city` VALUES ('46', '210800', '营口市', '210000');
INSERT INTO `t_address_city` VALUES ('47', '210900', '阜新市', '210000');
INSERT INTO `t_address_city` VALUES ('48', '211000', '辽阳市', '210000');
INSERT INTO `t_address_city` VALUES ('49', '211100', '盘锦市', '210000');
INSERT INTO `t_address_city` VALUES ('50', '211200', '铁岭市', '210000');
INSERT INTO `t_address_city` VALUES ('51', '211300', '朝阳市', '210000');
INSERT INTO `t_address_city` VALUES ('52', '211400', '葫芦岛市', '210000');
INSERT INTO `t_address_city` VALUES ('53', '220100', '长�
三级联动SQL语句及sql表
需积分: 1 11 浏览量
2022-09-07
16:39:57
上传
评论
收藏 66KB RAR 举报
不爱起名的我
- 粉丝: 8
- 资源: 1
最新资源
- PxCook-像素大厨Mac版本安装包
- 基于mysql和python的学生选课系统【课程设计(实验报告+源码)】
- PxCook-像素大厨Windows版本安装包
- aspose-words-23.12-jdk16 有水印
- [大模型部署]在C# Winform中使用文心一言ERNIE-3.5 4K 聊天模型
- python毕业设计-基于Django+OpenCV的二维码生成与识别系统设计与实现.zip
- python毕业设计-基于Django+OpenCV的二维码生成与识别系统设计与实现+使用说明.zip
- 基于STM32单片机空气监测系统设计源码+详细文档+配套全部资料(毕业设计).zip
- rdf0412-kcu116-pcie-c-2019-1.zip(XILINX KCU116 源码)
- 基于C#语言的winform界面火车票订票系统(源码+实验报告)
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
评论0