"省市县三级联动的SQL语句及建表语句示例"

5星 · 超过95%的资源 40 浏览量更新于2024-02-01 收藏 418KB PDF 举报

省市县三级联动的SQL语句是用于构建一个省市县信息管理系统的数据库表结构和数据操作语句。首先，我们需要建立省份信息表和城市信息表两个数据库表。省份信息表包括字段id为自增主键、code为省份编码、name为省份名称；城市信息表包括字段id为自增主键、code为城市编码、name为城市名称、provinceCode为所属省份编码。其中，省份信息表的建表语句为： 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 C; 接下来，我们需要插入省份和城市的数据信息。插入省份数据的SQL语句如下： INSERT INTO `t_address_province`(`code`, `name`) VALUES ('110000', '北京市'), ('120000', '天津市'), ('130000', '河北省'), ...... ('650000', '新疆维吾尔自治区'); 插入城市数据的SQL语句如下： INSERT INTO `t_address_city`(`code`, `name`, `provinceCode`) VALUES ('110100', '市辖区', '110000'), ('110200', '县', '110000'), ('120100', '市辖区', '120000'), ...... ('659004', '五家渠市', '650000'); 最后，我们需要编写查询省市县信息的SQL语句。查询所有省份信息的SQL语句如下： SELECT * FROM `t_address_province`; 查询指定省份下所有城市信息的SQL语句如下： SELECT * FROM `t_address_city` WHERE `provinceCode` = '110000'; 通过以上建表、插入和查询操作，我们可以实现一个完整的省市县三级联动的信息管理系统。用户可以根据需求查询和管理各个省市县的信息，方便地进行地区信息展示和统计分析。同时，通过数据库表的设计和SQL语句的操作，可以保证数据的完整性和一致性，提高系统的稳定性和可靠性。

INSERT INTO `t_address_town` VALUES (‘133’, ‘130626’, ‘定兴县’, ‘130600’);

INSERT INTO `t_address_town` VALUES (‘134’, ‘130627’, ‘唐　县’, ‘130600’);

INSERT INTO `t_address_town` VALUES (‘135’, ‘130628’, ‘高阳县’, ‘130600’);

INSERT INTO `t_address_town` VALUES (‘136’, ‘130629’, ‘容城县’, ‘130600’);

INSERT INTO `t_address_town` VALUES (‘137’, ‘130630’, ‘涞源县’, ‘130600’);

INSERT INTO `t_address_town` VALUES (‘138’, ‘130631’, ‘望都县’, ‘130600’);

INSERT INTO `t_address_town` VALUES (‘139’, ‘130632’, ‘安新县’, ‘130600’);

INSERT INTO `t_address_town` VALUES (‘140’, ‘130633’, ‘易　县’, ‘130600’);

INSERT INTO `t_address_town` VALUES (‘141’, ‘130634’, ‘曲阳县’, ‘130600’);

INSERT INTO `t_address_town` VALUES (‘142’, ‘130635’, ‘蠡　县’, ‘130600’);

INSERT INTO `t_address_town` VALUES (‘143’, ‘130636’, ‘顺平县’, ‘130600’);

INSERT INTO `t_address_town` VALUES (‘144’, ‘130637’, ‘博野县’, ‘130600’);

INSERT INTO `t_address_town` VALUES (‘145’, ‘130638’, ‘雄　县’, ‘130600’);

INSERT INTO `t_address_town` VALUES (‘146’, ‘130681’, ‘涿州市’, ‘130600’);

INSERT INTO `t_address_town` VALUES (‘147’, ‘130682’, ‘定州市’, ‘130600’);

INSERT INTO `t_address_town` VALUES (‘148’, ‘130683’, ‘安国市’, ‘130600’);

INSERT INTO `t_address_town` VALUES (‘149’, ‘130684’, ‘高碑店市’, ‘130600’);

INSERT INTO `t_address_town` VALUES (‘150’, ‘130701’, ‘市辖区’, ‘130700’);

INSERT INTO `t_address_town` VALUES (‘151’, ‘130702’, ‘桥东区’, ‘130700’);

INSERT INTO `t_address_town` VALUES (‘152’, ‘130703’, ‘桥西区’, ‘130700’);

INSERT INTO `t_address_town` VALUES (‘153’, ‘130705’, ‘宣化区’, ‘130700’);

INSERT INTO `t_address_town` VALUES (‘154’, ‘130706’, ‘下花园区’, ‘130700’);

INSERT INTO `t_address_town` VALUES (‘155’, ‘130721’, ‘宣化县’, ‘130700’);

INSERT INTO `t_address_town` VALUES (‘156’, ‘130722’, ‘张北县’, ‘130700’);

INSERT INTO `t_address_town` VALUES (‘157’, ‘130723’, ‘康保县’, ‘130700’);

INSERT INTO `t_address_town` VALUES (‘158’, ‘130724’, ‘沽源县’, ‘130700’);

INSERT INTO `t_address_town` VALUES (‘159’, ‘130725’, ‘尚义县’, ‘130700’);

INSERT INTO `t_address_town` VALUES (‘160’, ‘130726’, ‘蔚　县’, ‘130700’);

INSERT INTO `t_address_town` VALUES (‘161’, ‘130727’, ‘阳原县’, ‘130700’);

INSERT INTO `t_address_town` VALUES (‘162’, ‘130728’, ‘怀安县’, ‘130700’);

INSERT INTO `t_address_town` VALUES (‘163’, ‘130729’, ‘万全县’, ‘130700’);

INSERT INTO `t_address_town` VALUES (‘164’, ‘130730’, ‘怀来县’, ‘130700’);

INSERT INTO `t_address_town` VALUES (‘165’, ‘130731’, ‘涿鹿县’, ‘130700’);

INSERT INTO `t_address_town` VALUES (‘166’, ‘130732’, ‘赤城县’, ‘130700’);

INSERT INTO `t_address_town` VALUES (‘167’, ‘130733’, ‘崇礼县’, ‘130700’);

INSERT INTO `t_address_town` VALUES (‘168’, ‘130801’, ‘市辖区’, ‘130800’);

INSERT INTO `t_address_town` VALUES (‘169’, ‘130802’, ‘双桥区’, ‘130800’);

INSERT INTO `t_address_town` VALUES (‘170’, ‘130803’, ‘双滦区’, ‘130800’);

INSERT INTO `t_address_town` VALUES (‘171’, ‘130804’, ‘鹰手营子矿区’, ‘130800’);

INSERT INTO `t_address_town` VALUES (‘172’, ‘130821’, ‘承德县’, ‘130800’);

INSERT INTO `t_address_town` VALUES (‘173’, ‘130822’, ‘兴隆县’, ‘130800’);

INSERT INTO `t_address_town` VALUES (‘174’, ‘130823’, ‘平泉县’, ‘130800’);

INSERT INTO `t_address_town` VALUES (‘175’, ‘130824’, ‘滦平县’, ‘130800’);

INSERT INTO `t_address_town` VALUES (‘176’, ‘130825’, ‘隆化县’, ‘130800’);

INSERT INTO `t_address_town` VALUES (‘177’, ‘130826’, ‘丰宁满族自治县’, ‘130800’);

INSERT INTO `t_address_town` VALUES (‘178’, ‘130827’, ‘宽城满族自治县’, ‘130800’);

INSERT INTO `t_address_town` VALUES (‘179’, ‘130828’, ‘围场满族蒙古族自治县’, ‘130800’);

INSERT INTO `t_address_town` VALUES (‘180’, ‘130901’, ‘市辖区’, ‘130900’);

INSERT INTO `t_address_town` VALUES (‘181’, ‘130902’, ‘新华区’, ‘130900’);

INSERT INTO `t_address_town` VALUES (‘182’, ‘130903’, ‘运河区’, ‘130900’);

INSERT INTO `t_address_town` VALUES (‘183’, ‘130921’, ‘沧　县’, ‘130900’);

INSERT INTO `t_address_town` VALUES (‘184’, ‘130922’, ‘青　县’, ‘130900’);

INSERT INTO `t_address_town` VALUES (‘185’, ‘130923’, ‘东光县’, ‘130900’);

INSERT INTO `t_address_town` VALUES (‘186’, ‘130924’, ‘海兴县’, ‘130900’);

INSERT INTO `t_address_town` VALUES (‘187’, ‘130925’, ‘盐山县’, ‘130900’);

INSERT INTO `t_address_town` VALUES (‘188’, ‘130926’, ‘肃宁县’, ‘130900’);

INSERT INTO `t_address_town` VALUES (‘189’, ‘130927’, ‘南皮县’, ‘130900’);

INSERT INTO `t_address_town` VALUES (‘190’, ‘130928’, ‘吴桥县’, ‘130900’);

INSERT INTO `t_address_town` VALUES (‘191’, ‘130929’, ‘献　县’, ‘130900’);

INSERT INTO `t_address_town` VALUES (‘192’, ‘130930’, ‘孟村回族自治县’, ‘130900’);

INSERT INTO `t_address_town` VALUES (‘193’, ‘130981’, ‘泊头市’, ‘130900’);

INSERT INTO `t_address_town` VALUES (‘194’, ‘130982’, ‘任丘市’, ‘130900’);

INSERT INTO `t_address_town` VALUES (‘195’, ‘130983’, ‘黄骅市’, ‘130900’);

INSERT INTO `t_address_town` VALUES (‘196’, ‘130984’, ‘河间市’, ‘130900’);

INSERT INTO `t_address_town` VALUES (‘197’, ‘131001’, ‘市辖区’, ‘131000’);

INSERT INTO `t_address_town` VALUES (‘198’, ‘131002’, ‘安次区’, ‘131000’);

INSERT INTO `t_address_town` VALUES (‘199’, ‘131003’, ‘广阳区’, ‘131000’);

INSERT INTO `t_address_town` VALUES (‘200’, ‘131022’, ‘固安县’, ‘131000’);

INSERT INTO `t_address_town` VALUES (‘201’, ‘131023’, ‘永清县’, ‘131000’);

INSERT INTO `t_address_town` VALUES (‘202’, ‘131024’, ‘香河县’, ‘131000’);

INSERT INTO `t_address_town` VALUES (‘203’, ‘131025’, ‘大城县’, ‘131000’);

INSERT INTO `t_address_town` VALUES (‘204’, ‘131026’, ‘文安县’, ‘131000’);

INSERT INTO `t_address_town` VALUES (‘205’, ‘131028’, ‘大厂回族自治县’, ‘131000’);

INSERT INTO `t_address_town` VALUES (‘206’, ‘131081’, ‘霸州市’, ‘131000’);

INSERT INTO `t_address_town` VALUES (‘207’, ‘131082’, ‘三河市’, ‘131000’);

INSERT INTO `t_address_town` VALUES (‘208’, ‘131101’, ‘市辖区’, ‘131100’);

INSERT INTO `t_address_town` VALUES (‘209’, ‘131102’, ‘桃城区’, ‘131100’);

INSERT INTO `t_address_town` VALUES (‘210’, ‘131121’, ‘枣强县’, ‘131100’);

INSERT INTO `t_address_town` VALUES (‘211’, ‘131122’, ‘武邑县’, ‘131100’);

INSERT INTO `t_address_town` VALUES (‘212’, ‘131123’, ‘武强县’, ‘131100’);

INSERT INTO `t_address_town` VALUES (‘213’, ‘131124’, ‘饶阳县’, ‘131100’);

INSERT INTO `t_address_town` VALUES (‘214’, ‘131125’, ‘安平县’, ‘131100’);

INSERT INTO `t_address_town` VALUES (‘215’, ‘131126’, ‘故城县’, ‘131100’);

INSERT INTO `t_address_town` VALUES (‘216’, ‘131127’, ‘景　县’, ‘131100’);

INSERT INTO `t_address_town` VALUES (‘217’, ‘131128’, ‘阜城县’, ‘131100’);

INSERT INTO `t_address_town` VALUES (‘218’, ‘131181’, ‘冀州市’, ‘131100’);

INSERT INTO `t_address_town` VALUES (‘219’, ‘131182’, ‘深州市’, ‘131100’);

INSERT INTO `t_address_town` VALUES (‘220’, ‘140101’, ‘市辖区’, ‘140100’);

INSERT INTO `t_address_town` VALUES (‘221’, ‘140105’, ‘小店区’, ‘140100’);

INSERT INTO `t_address_town` VALUES (‘222’, ‘140106’, ‘迎泽区’, ‘140100’);

INSERT INTO `t_address_town` VALUES (‘223’, ‘140107’, ‘杏花岭区’, ‘140100’);

INSERT INTO `t_address_town` VALUES (‘224’, ‘140108’, ‘尖草坪区’, ‘140100’);

INSERT INTO `t_address_town` VALUES (‘225’, ‘140109’, ‘万柏林区’, ‘140100’);

INSERT INTO `t_address_town` VALUES (‘226’, ‘140110’, ‘晋源区’, ‘140100’);

INSERT INTO `t_address_town` VALUES (‘227’, ‘140121’, ‘清徐县’, ‘140100’);

INSERT INTO `t_address_town` VALUES (‘228’, ‘140122’, ‘阳曲县’, ‘140100’);

INSERT INTO `t_address_town` VALUES (‘229’, ‘140123’, ‘娄烦县’, ‘140100’);

INSERT INTO `t_address_town` VALUES (‘230’, ‘140181’, ‘古交市’, ‘140100’);

INSERT INTO `t_address_town` VALUES (‘231’, ‘140201’, ‘市辖区’, ‘140200’);

INSERT INTO `t_address_town` VALUES (‘232’, ‘140202’, ‘城　区’, ‘140200’);

INSERT INTO `t_address_town` VALUES (‘233’, ‘140203’, ‘矿　区’, ‘140200’);

INSERT INTO `t_address_town` VALUES (‘234’, ‘140211’, ‘南郊区’, ‘140200’);

INSERT INTO `t_address_town` VALUES (‘235’, ‘140212’, ‘新荣区’, ‘140200’);

INSERT INTO `t_address_town` VALUES (‘236’, ‘140221’, ‘阳高县’, ‘140200’);

INSERT INTO `t_address_town` VALUES (‘237’, ‘140222’, ‘天镇县’, ‘140200’);

INSERT INTO `t_address_town` VALUES (‘238’, ‘140223’, ‘广灵县’, ‘140200’);

INSERT INTO `t_address_town` VALUES (‘239’, ‘140224’, ‘灵丘县’, ‘140200’);

INSERT INTO `t_address_town` VALUES (‘240’, ‘140225’, ‘浑源县’, ‘140200’);

INSERT INTO `t_address_town` VALUES (‘241’, ‘140226’, ‘左云县’, ‘140200’);

INSERT INTO `t_address_town` VALUES (‘242’, ‘140227’, ‘大同县’, ‘140200’);

INSERT INTO `t_address_town` VALUES (‘243’, ‘140301’, ‘市辖区’, ‘140300’);

INSERT INTO `t_address_town` VALUES (‘244’, ‘140302’, ‘城　区’, ‘140300’);

INSERT INTO `t_address_town` VALUES (‘245’, ‘140303’, ‘矿　区’, ‘140300’);

INSERT INTO `t_address_town` VALUES (‘246’, ‘140311’, ‘郊　区’, ‘140300’);

INSERT INTO `t_address_town` VALUES (‘247’, ‘140321’, ‘平定县’, ‘140300’);

INSERT INTO `t_address_town` VALUES (‘248’, ‘140322’, ‘盂　县’, ‘140300’);

INSERT INTO `t_address_town` VALUES (‘249’, ‘140401’, ‘市辖区’, ‘140400’);

INSERT INTO `t_address_town` VALUES (‘250’, ‘140402’, ‘城　区’, ‘140400’);

INSERT INTO `t_address_town` VALUES (‘251’, ‘140411’, ‘郊　区’, ‘140400’);

INSERT INTO `t_address_town` VALUES (‘252’, ‘140421’, ‘长治县’, ‘140400’);

INSERT INTO `t_address_town` VALUES (‘253’, ‘140423’, ‘襄垣县’, ‘140400’);

INSERT INTO `t_address_town` VALUES (‘254’, ‘140424’, ‘屯留县’, ‘140400’);

INSERT INTO `t_address_town` VALUES (‘255’, ‘140425’, ‘平顺县’, ‘140400’);

INSERT INTO `t_address_town` VALUES (‘256’, ‘140426’, ‘黎城县’, ‘140400’);

INSERT INTO `t_address_town` VALUES (‘257’, ‘140427’, ‘壶关县’, ‘140400’);

INSERT INTO `t_address_town` VALUES (‘258’, ‘140428’, ‘长子县’, ‘140400’);

INSERT INTO `t_address_town` VALUES (‘259’, ‘140429’, ‘武乡县’, ‘140400’);

INSERT INTO `t_address_town` VALUES (‘260’, ‘140430’, ‘沁　县’, ‘140400’);

INSERT INTO `t_address_town` VALUES (‘261’, ‘140431’, ‘沁源县’, ‘140400’);

INSERT INTO `t_address_town` VALUES (‘262’, ‘140481’, ‘潞城市’, ‘140400’);

INSERT INTO `t_address_town` VALUES (‘263’, ‘140501’, ‘市辖区’, ‘140500’);

INSERT INTO `t_address_town` VALUES (‘264’, ‘140502’, ‘城　区’, ‘140500’);

INSERT INTO `t_address_town` VALUES (‘265’, ‘140521’, ‘沁水县’, ‘140500’);

INSERT INTO `t_address_town` VALUES (‘266’, ‘140522’, ‘阳城县’, ‘140500’);

INSERT INTO `t_address_town` VALUES (‘267’, ‘140524’, ‘陵川县’, ‘140500’);

INSERT INTO `t_address_town` VALUES (‘268’, ‘140525’, ‘泽州县’, ‘140500’);

INSERT INTO `t_address_town` VALUES (‘269’, ‘140581’, ‘高平市’, ‘140500’);

INSERT INTO `t_address_town` VALUES (‘270’, ‘140601’, ‘市辖区’, ‘140600’);

INSERT INTO `t_address_town` VALUES (‘271’, ‘140602’, ‘朔城区’, ‘140600’);

INSERT INTO `t_address_town` VALUES (‘272’, ‘140603’, ‘平鲁区’, ‘140600’);

INSERT INTO `t_address_town` VALUES (‘273’, ‘140621’, ‘山阴县’, ‘140600’);

INSERT INTO `t_address_town` VALUES (‘274’, ‘140622’, ‘应　县’, ‘140600’);

INSERT INTO `t_address_town` VALUES (‘275’, ‘140623’, ‘右玉县’, ‘140600’);

INSERT INTO `t_address_town` VALUES (‘276’, ‘140624’, ‘怀仁县’, ‘140600’);

INSERT INTO `t_address_town` VALUES (‘277’, ‘140701’, ‘市辖区’, ‘140700’);

INSERT INTO `t_address_town` VALUES (‘278’, ‘140702’, ‘榆次区’, ‘140700’);

INSERT INTO `t_address_town` VALUES (‘279’, ‘140721’, ‘榆社县’, ‘140700’);

INSERT INTO `t_address_town` VALUES (‘280’, ‘140722’, ‘左权县’, ‘140700’);

INSERT INTO `t_address_town` VALUES (‘281’, ‘140723’, ‘和顺县’, ‘140700’);

INSERT INTO `t_address_town` VALUES (‘282’, ‘140724’, ‘昔阳县’, ‘140700’);

INSERT INTO `t_address_town` VALUES (‘283’, ‘140725’, ‘寿阳县’, ‘140700’);

INSERT INTO `t_address_town` VALUES (‘284’, ‘140726’, ‘太谷县’, ‘140700’);

INSERT INTO `t_address_town` VALUES (‘285’, ‘140727’, ‘祁　县’, ‘140700’);

INSERT INTO `t_address_town` VALUES (‘286’, ‘140728’, ‘平遥县’, ‘140700’);

INSERT INTO `t_address_town` VALUES (‘287’, ‘140729’, ‘灵石县’, ‘140700’);

INSERT INTO `t_address_town` VALUES (‘288’, ‘140781’, ‘介休市’, ‘140700’);

INSERT INTO `t_address_town` VALUES (‘289’, ‘140801’, ‘市辖区’, ‘140800’);

INSERT INTO `t_address_town` VALUES (‘290’, ‘140802’, ‘盐湖区’, ‘140800’);

INSERT INTO `t_address_town` VALUES (‘291’, ‘140821’, ‘临猗县’, ‘140800’);

INSERT INTO `t_address_town` VALUES (‘292’, ‘140822’, ‘万荣县’, ‘140800’);

INSERT INTO `t_address_town` VALUES (‘293’, ‘140823’, ‘闻喜县’, ‘140800’);

INSERT INTO `t_address_town` VALUES (‘294’, ‘140824’, ‘稷山县’, ‘140800’);

INSERT INTO `t_address_town` VALUES (‘295’, ‘140825’, ‘新绛县’, ‘140800’);

INSERT INTO `t_address_town` VALUES (‘296’, ‘140826’, ‘绛　县’, ‘140800’);

INSERT INTO `t_address_town` VALUES (‘297’, ‘140827’, ‘垣曲县’, ‘140800’);

INSERT INTO `t_address_town` VALUES (‘298’, ‘140828’, ‘夏　县’, ‘140800’);

INSERT INTO `t_address_town` VALUES (‘299’, ‘140829’, ‘平陆县’, ‘140800’);

INSERT INTO `t_address_town` VALUES (‘300’, ‘140830’, ‘芮城县’, ‘140800’);

INSERT INTO `t_address_town` VALUES (‘301’, ‘140881’, ‘永济市’, ‘140800’);

INSERT INTO `t_address_town` VALUES (‘302’, ‘140882’, ‘河津市’, ‘140800’);

INSERT INTO `t_address_town` VALUES (‘303’, ‘140901’, ‘市辖区’, ‘140900’);

INSERT INTO `t_address_town` VALUES (‘304’, ‘140902’, ‘忻府区’, ‘140900’);

INSERT INTO `t_address_town` VALUES (‘305’, ‘140921’, ‘定襄县’, ‘140900’);

INSERT INTO `t_address_town` VALUES (‘306’, ‘140922’, ‘五台县’, ‘140900’);

INSERT INTO `t_address_town` VALUES (‘307’, ‘140923’, ‘代　县’, ‘140900’);

INSERT INTO `t_address_town` VALUES (‘308’, ‘140924’, ‘繁峙县’, ‘140900’);

INSERT INTO `t_address_town` VALUES (‘309’, ‘140925’, ‘宁武县’, ‘140900’);

INSERT INTO `t_address_town` VALUES (‘310’, ‘140926’, ‘静乐县’, ‘140900’);

INSERT INTO `t_address_town` VALUES (‘311’, ‘140927’, ‘神池县’, ‘140900’);

INSERT INTO `t_address_town` VALUES (‘312’, ‘140928’, ‘五寨县’, ‘140900’);

INSERT INTO `t_address_town` VALUES (‘313’, ‘140929’, ‘岢岚县’, ‘140900’);

INSERT INTO `t_address_town` VALUES (‘314’, ‘140930’, ‘河曲县’, ‘140900’);

INSERT INTO `t_address_town` VALUES (‘315’, ‘140931’, ‘保德县’, ‘140900’);

INSERT INTO `t_address_town` VALUES (‘316’, ‘140932’, ‘偏关县’, ‘140900’);

INSERT INTO `t_address_town` VALUES (‘317’, ‘140981’, ‘原平市’, ‘140900’);

INSERT INTO `t_address_town` VALUES (‘318’, ‘141001’, ‘市辖区’, ‘141000’);

INSERT INTO `t_address_town` VALUES (‘319’, ‘141002’, ‘尧都区’, ‘141000’);

INSERT INTO `t_address_town` VALUES (‘320’, ‘141021’, ‘曲沃县’, ‘141000’);

INSERT INTO `t_address_town` VALUES (‘321’, ‘141022’, ‘翼城县’, ‘141000’);

INSERT INTO `t_address_town` VALUES (‘322’, ‘141023’, ‘襄汾县’, ‘141000’);

INSERT INTO `t_address_town` VALUES (‘323’, ‘141024’, ‘洪洞县’, ‘141000’);

INSERT INTO `t_address_town` VALUES (‘324’, ‘141025’, ‘古　县’, ‘141000’);

INSERT INTO `t_address_town` VALUES (‘325’, ‘141026’, ‘安泽县’, ‘141000’);

INSERT INTO `t_address_town` VALUES (‘326’, ‘141027’, ‘浮山县’, ‘141000’);

INSERT INTO `t_address_town` VALUES (‘327’, ‘141028’, ‘吉　县’, ‘141000’);

INSERT INTO `t_address_town` VALUES (‘328’, ‘141029’, ‘乡宁县’, ‘141000’);

INSERT INTO `t_address_town` VALUES (‘329’, ‘141030’, ‘大宁县’, ‘141000’);

INSERT INTO `t_address_town` VALUES (‘330’, ‘141031’, ‘隰　县’, ‘141000’);

INSERT INTO `t_address_town` VALUES (‘331’, ‘141032’, ‘永和县’, ‘141000’);

INSERT INTO `t_address_town` VALUES (‘332’, ‘141033’, ‘蒲　县’, ‘141000’);

INSERT INTO `t_address_town` VALUES (‘333’, ‘141034’, ‘汾西县’, ‘141000’);

INSERT INTO `t_address_town` VALUES (‘334’, ‘141081’, ‘侯马市’, ‘141000’);

INSERT INTO `t_address_town` VALUES (‘335’, ‘141082’, ‘霍州市’, ‘141000’);

INSERT INTO `t_address_town` VALUES (‘336’, ‘141101’, ‘市辖区’, ‘141100’);

剩余52页未读，继续阅读

weixin_38721565

粉丝: 3
资源: 916

"省市县三级联动的SQL语句及建表语句示例"

2020最新全国省市县区三级联动数据库表

省市区sql文件一份在一张表里一份在三张表里.rar

全国省市县数据库sql文件

省市县 三级联动 sql语句 与你共分享

最新参考淘宝地址省市区三级联动sql语句,只需修改字段和表名就可以完成插入.

全国省市三级联动的sql语句

省市区三级联动通用sql语句

省市县三级联动DB2完整数据库sql语句

2018最新省市县三级联动，同表父子级SQL语句

香港澳门台湾三级联动SQL语句

最新资源

省市县三级联动 sql语句与你共分享