使用Navicat生成全国省份城市SQL数据库

提示：文章写完后，目录可以自动生成，如何生成可参考右边的帮助文档

---

前言

网上找了关于省份-城市的数据库，不合适自己的，现在自己写一个。你们可以直接粘贴拿去用。

一、表

省份表zyx_province

城市表zyx_city

二、使用步骤

1.引入库

添加省份库

insert into zyx_province ( province_id ,province_name)   values(1,'北京市');
insert into zyx_province ( province_id ,province_name)  values(2,'天津市');
insert into zyx_province ( province_id ,province_name)  values(3,'上海市');
insert into zyx_province ( province_id ,province_name) values(4,'重庆市');
insert into zyx_province ( province_id ,province_name)  values(5,'河北省');
insert into zyx_province ( province_id ,province_name) values(6,'山西省');
insert into zyx_province ( province_id ,province_name)  values(7,'台湾省');
insert into zyx_province ( province_id ,province_name)  values(8,'辽宁省');
insert into zyx_province ( province_id ,province_name)  values(9,'吉林省');
insert into zyx_province ( province_id ,province_name) values(10,'黑龙江省');
insert into zyx_province ( province_id ,province_name) values(11,'江苏省');
insert into zyx_province ( province_id ,province_name) values(12,'浙江省');
insert into zyx_province ( province_id ,province_name) values(13,'安徽省');
insert into zyx_province ( province_id ,province_name) values(14,'福建省');
insert into zyx_province ( province_id ,province_name) values(15,'江西省');
insert into zyx_province ( province_id ,province_name) values(16,'山东省');
insert into zyx_province ( province_id ,province_name) values(17,'河南省');
insert into zyx_province ( province_id ,province_name) values(18,'湖北省');
insert into zyx_province ( province_id ,province_name) values(19,'湖南省');
insert into zyx_province ( province_id ,province_name) values(20,'广东省');
insert into zyx_province ( province_id ,province_name) values(21,'甘肃省');
insert into zyx_province ( province_id ,province_name) values(22,'四川省');
insert into zyx_province ( province_id ,province_name) values(23,'贵州省');
insert into zyx_province ( province_id ,province_name) values(24,'海南省');
insert into zyx_province ( province_id ,province_name) values(25,'云南省');
insert into zyx_province ( province_id ,province_name) values(26,'青海省');
insert into zyx_province ( province_id ,province_name) values(27,'陕西省');
insert into zyx_province ( province_id ,province_name) values(28,'广西壮族自治区');
insert into zyx_province ( province_id ,province_name) values(29,'西藏自治区');
insert into zyx_province ( province_id ,province_name) values(30,'宁夏回族自治区');
insert into zyx_province ( province_id ,province_name) values(31,'新疆维吾尔自治区');
insert into zyx_province ( province_id ,province_name) values(32,'内蒙古自治区');
insert into zyx_province ( province_id ,province_name) values(33,'澳门特别行政区');
insert into zyx_province ( province_id ,province_name) values(34,'香港特别行政区');

2.添加城市数据

代码如下（示例）：

insert into zyx_city (city_id,city_name,province_id) values(1,'北京市',1);
insert into zyx_city (city_id,city_name,province_id) values(2,'天津市',2);
insert into zyx_city (city_id,city_name,province_id) values(3,'上海市',3);
insert into zyx_city (city_id,city_name,province_id) values(4,'重庆市',4);
 --  6山西省 11个城市
insert into  zyx_city (city_id,city_name,province_id) values(5,'太原市',6);
insert into  zyx_city (city_id,city_name,province_id) values(6,'大同市',6);
insert into  zyx_city (city_id,city_name,province_id) values(7,'阳泉市',6);
insert into  zyx_city (city_id,city_name,province_id) values(8,'长治市',6);
insert into  zyx_city (city_id,city_name,province_id) values(9,'晋城市',6);
insert into  zyx_city (city_id,city_name,province_id) values(10,'朔州市',6);
insert into  zyx_city (city_id,city_name,province_id) values(11,'晋中市',6);
insert into  zyx_city (city_id,city_name,province_id) values(12,'运城市',6);
insert into  zyx_city (city_id,city_name,province_id) values(13,'忻州市',6);
insert into  zyx_city (city_id,city_name,province_id) values(14,'临汾市',6);
insert into  zyx_city (city_id,city_name,province_id) values(15,'吕梁市',6);
 --  8辽宁省 14个地级市
insert into  zyx_city (city_id,city_name,province_id) values(16,'沈阳市',8);
insert into  zyx_city (city_id,city_name,province_id) values(17,'大连市',8);
insert into  zyx_city (city_id,city_name,province_id) values(18,'抚顺市',8);
insert into  zyx_city (city_id,city_name,province_id) values(19,'本溪市',8);
insert into  zyx_city (city_id,city_name,province_id) values(20,'丹东市',8);
insert into  zyx_city (city_id,city_name,province_id) values(21,'锦州市',8);
insert into  zyx_city (city_id,city_name,province_id) values(22,'营口市',8);
insert into  zyx_city (city_id,city_name,province_id) values(23,'阜新市',8);
insert into  zyx_city (city_id,city_name,province_id) values(24,'辽阳市',8);
insert into  zyx_city (city_id,city_name,province_id) values(25,'盘锦市',8);
insert into  zyx_city (city_id,city_name,province_id) values(26,'铁岭市',8);
insert into  zyx_city (city_id,city_name,province_id) values(27,'朝阳市',8);
insert into  zyx_city (city_id,city_name,province_id) values(28,'葫芦岛市',8);
 --  9吉林省(2006年，辖：8个地级市、1个自治州；20个市辖区、20个县级市、17个县、3个自治县。)
insert into  zyx_city (city_id,city_name,province_id) values(29,'长春市',9);
insert into  zyx_city (city_id,city_name,province_id) values(30,'吉林市',9);
insert into  zyx_city (city_id,city_name,province_id) values(31,'四平市',9);
insert into  zyx_city (city_id,city_name,province_id) values(32,'辽源市',9);
insert into  zyx_city (city_id,city_name,province_id) values(33,'通化市',9);
insert into  zyx_city (city_id,city_name,province_id) values(34,'白山市',9);
insert into  zyx_city (city_id,city_name,province_id) values(35,'松原市',9);
insert into  zyx_city (city_id,city_name,province_id) values(36,'白城市',9);
insert into  zyx_city (city_id,city_name,province_id) values(37,'延边朝鲜族自治州',9);
 --  10黑龙江省(2006年，辖：12地级市、1地区；64市辖区、18县级市、45县、1自治县)
insert into  zyx_city (city_id,city_name,province_id) values(38,'哈尔滨市',10);
insert into  zyx_city (city_id,city_name,province_id) values(39,'齐齐哈尔市',10);
insert into  zyx_city (city_id,city_name,province_id) values(40,'鹤 岗 市',10);
insert into  zyx_city (city_id,city_name,province_id) values(41,'双鸭山市',10);
insert into  zyx_city (city_id,city_name,province_id) values(42,'鸡 西 市',10);
insert into  zyx_city (city_id,city_name,province_id) values(43,'大 庆 市',10);
insert into  zyx_city (city_id,city_name,province_id) values(44,'伊 春 市',10);
insert into  zyx_city (city_id,city_name,province_id) values(45,'牡丹江市',10);
insert into  zyx_city (city_id,city_name,province_id) values(46,'佳木斯市',10);
insert into  zyx_city (city_id,city_name,province_id) values(47,'七台河市',10);
insert into  zyx_city (city_id,city_name,province_id) values(48,'黑 河 市',10);
insert into  zyx_city (city_id,city_name,province_id) values(49,'绥 化 市',10);
insert into  zyx_city (city_id,city_name,province_id) values(50,'大兴安岭地区',10);
 --  11江苏省(2005年辖：13个地级市；54个市辖区、27个县级市、25个县)
insert into  zyx_city (city_id,city_name,province_id) values(51,'南京市',11);
insert into  zyx_city (city_id,city_name,province_id) values(52,'无锡市',11);
insert into  zyx_city (city_id,city_name,province_id) values(53,'徐州市',11);
insert into  zyx_city (city_id,city_name,province_id) values(54,'常州市',11);
insert into  zyx_city (city_id,city_name,province_id) values(55,'苏州市',11);
insert into  zyx_city (city_id,city_name,province_id) values(56,'南通市',11);
insert into  zyx_city (city_id,city_name,province_id) values(57,'连云港市',11);
insert into  zyx_city (city_id,city_name,province_id) values(58,'淮安市',11);
insert into  zyx_city (city_id,city_name,province_id) values(59,'盐城市',11);
insert into  zyx_city (city_id,city_name,province_id) values(60,'扬州市',11);
insert into  zyx_city (city_id,city_name,province_id) values(61,'镇江市',11);
insert into  zyx_city (city_id,city_name,province_id) values(62,'泰州市',11);
insert into  zyx_city (city_id,city_name,province_id) values(63,'宿迁市',11);
 --  12浙江省(2006年，辖：11个地级市；32个市辖区、22个县级市、35个县、1个自治县。)
insert into  zyx_city (city_id,city_name,province_id) values(64,'杭州市',12);
insert into  zy