當(dāng)前位置：首頁(yè) > 运维知识 > 数据库 >内容正文

数据库

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

發(fā)布時(shí)間：2024/1/1 数据库 33 豆豆

生活随笔收集整理的這篇文章主要介紹了使用Navicat生成全国省份城市SQL数据库小編覺(jué)得挺不錯(cuò)的,現(xiàn)在分享給大家,幫大家做個(gè)參考.

提示：文章寫完后，目錄可以自動(dòng)生成，如何生成可參考右邊的幫助文檔

文章目錄

前言
一、表
二、使用步驟
- 1.引入庫(kù)
- 2.添加城市數(shù)據(jù)

前言

網(wǎng)上找了關(guān)于省份-城市的數(shù)據(jù)庫(kù)，不合適自己的，現(xiàn)在自己寫一個(gè)。你們可以直接粘貼拿去用。

一、表

省份表zyx_province

城市表zyx_city

二、使用步驟

1.引入庫(kù)

添加省份庫(kù)

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,'臺(tái)灣省'); 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,'廣西壯族自治區(qū)'); insert into zyx_province ( province_id ,province_name) values(29,'西藏自治區(qū)'); insert into zyx_province ( province_id ,province_name) values(30,'寧夏回族自治區(qū)'); insert into zyx_province ( province_id ,province_name) values(31,'新疆維吾爾自治區(qū)'); insert into zyx_province ( province_id ,province_name) values(32,'內(nèi)蒙古自治區(qū)'); insert into zyx_province ( province_id ,province_name) values(33,'澳門特別行政區(qū)'); insert into zyx_province ( province_id ,province_name) values(34,'香港特別行政區(qū)');

2.添加城市數(shù)據(jù)

代碼如下（示例）：

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個(gè)城市 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,'陽(yáng)泉市',6); insert into zyx_city (city_id,city_name,province_id) values(8,'長(zhǎng)治市',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,'運(yùn)城市',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個(gè)地級(jí)市 insert into zyx_city (city_id,city_name,province_id) values(16,'沈陽(yáng)市',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,'營(yíng)口市',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,'遼陽(yáng)市',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,'朝陽(yáng)市',8); insert into zyx_city (city_id,city_name,province_id) values(28,'葫蘆島市',8);-- 9吉林省(2006年，轄：8個(gè)地級(jí)市、1個(gè)自治州；20個(gè)市轄區(qū)、20個(gè)縣級(jí)市、17個(gè)縣、3個(gè)自治縣。) insert into zyx_city (city_id,city_name,province_id) values(29,'長(zhǎng)春市',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地級(jí)市、1地區(qū)；64市轄區(qū)、18縣級(jí)市、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,'七臺(tái)河市',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,'大興安嶺地區(qū)',10);-- 11江蘇省(2005年轄：13個(gè)地級(jí)市；54個(gè)市轄區(qū)、27個(gè)縣級(jí)市、25個(gè)縣) 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,'無(wú)錫市',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,'揚(yáng)州市',11); insert into zyx_city (city_id,city_name,province_id) values(61,'鎮(zhèn)江市',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個(gè)地級(jí)市；32個(gè)市轄區(qū)、22個(gè)縣級(jí)市、35個(gè)縣、1個(gè)自治縣。) insert into zyx_city (city_id,city_name,province_id) values(64,'杭州市',12); insert into zyx_city (city_id,city_name,province_id) values(65,'寧波市',12); insert into zyx_city (city_id,city_name,province_id) values(66,'溫州市',12); insert into zyx_city (city_id,city_name,province_id) values(67,'嘉興市',12); insert into zyx_city (city_id,city_name,province_id) values(68,'湖州市',12); insert into zyx_city (city_id,city_name,province_id) values(69,'紹興市',12); insert into zyx_city (city_id,city_name,province_id) values(70,'金華市',12); insert into zyx_city (city_id,city_name,province_id) values(71,'衢州市',12); insert into zyx_city (city_id,city_name,province_id) values(72,'舟山市',12); insert into zyx_city (city_id,city_name,province_id) values(73,'臺(tái)州市',12); insert into zyx_city (city_id,city_name,province_id) values(74,'麗水市',12);-- 13安徽省(2005年轄：17個(gè)地級(jí)市；44個(gè)市轄區(qū)、5縣個(gè)級(jí)市、56個(gè)縣。); insert into zyx_city (city_id,city_name,province_id) values(75,'合肥市',13); insert into zyx_city (city_id,city_name,province_id) values(76,'蕪湖市',13); insert into zyx_city (city_id,city_name,province_id) values(77,'蚌埠市',13); insert into zyx_city (city_id,city_name,province_id) values(78,'淮南市',13); insert into zyx_city (city_id,city_name,province_id) values(79,'馬鞍山市',13); insert into zyx_city (city_id,city_name,province_id) values(80,'淮北市',13); insert into zyx_city (city_id,city_name,province_id) values(81,'銅陵市',13); insert into zyx_city (city_id,city_name,province_id) values(82,'安慶市',13); insert into zyx_city (city_id,city_name,province_id) values(83,'黃山市',13); insert into zyx_city (city_id,city_name,province_id) values(84,'滁州市',13); insert into zyx_city (city_id,city_name,province_id) values(85,'阜陽(yáng)市',13); insert into zyx_city (city_id,city_name,province_id) values(86,'宿州市',13); insert into zyx_city (city_id,city_name,province_id) values(87,'巢湖市',13); insert into zyx_city (city_id,city_name,province_id) values(88,'六安市',13); insert into zyx_city (city_id,city_name,province_id) values(89,'亳州市',13); insert into zyx_city (city_id,city_name,province_id) values(90,'池州市',13); insert into zyx_city (city_id,city_name,province_id) values(91,'宣城市',13);-- 14福建省(2006年轄：9個(gè)地級(jí)市；26個(gè)市轄區(qū)、14個(gè)縣級(jí)市、45個(gè)縣。); insert into zyx_city (city_id,city_name,province_id) values(92,'福州市',14); insert into zyx_city (city_id,city_name,province_id) values(93,'廈門市',14); insert into zyx_city (city_id,city_name,province_id) values(94,'莆田市',14); insert into zyx_city (city_id,city_name,province_id) values(95,'三明市',14); insert into zyx_city (city_id,city_name,province_id) values(96,'泉州市',14); insert into zyx_city (city_id,city_name,province_id) values(97,'漳州市',14); insert into zyx_city (city_id,city_name,province_id) values(98,'南平市',14); insert into zyx_city (city_id,city_name,province_id) values(99,'龍巖市',14); insert into zyx_city (city_id,city_name,province_id) values(100,'寧德市',14);-- 15江西省(2006年全省轄：11個(gè)地級(jí)市；19個(gè)市轄區(qū)、10個(gè)縣級(jí)市、70個(gè)縣。); insert into zyx_city (city_id,city_name,province_id) values(101,'南昌市',15); insert into zyx_city (city_id,city_name,province_id) values(102,'景德鎮(zhèn)市',15); insert into zyx_city (city_id,city_name,province_id) values(103,'萍鄉(xiāng)市',15); insert into zyx_city (city_id,city_name,province_id) values(104,'九江市',15); insert into zyx_city (city_id,city_name,province_id) values(105,'新余市',15); insert into zyx_city (city_id,city_name,province_id) values(106,'鷹潭市',15); insert into zyx_city (city_id,city_name,province_id) values(107,'贛州市',15); insert into zyx_city (city_id,city_name,province_id) values(108,'吉安市',15); insert into zyx_city (city_id,city_name,province_id) values(109,'宜春市',15); insert into zyx_city (city_id,city_name,province_id) values(110,'撫州市',15); insert into zyx_city (city_id,city_name,province_id) values(111,'上饒市',15);-- 16山東省(2005年，轄：17個(gè)地級(jí)市；49個(gè)市轄區(qū)、31個(gè)縣級(jí)市、60個(gè)縣。); insert into zyx_city (city_id,city_name,province_id) values(112,'濟(jì)南市',16); insert into zyx_city (city_id,city_name,province_id) values(113,'青島市',16); insert into zyx_city (city_id,city_name,province_id) values(114,'淄博市',16); insert into zyx_city (city_id,city_name,province_id) values(115,'棗莊市',16); insert into zyx_city (city_id,city_name,province_id) values(116,'東營(yíng)市',16); insert into zyx_city (city_id,city_name,province_id) values(117,'煙臺(tái)市',16); insert into zyx_city (city_id,city_name,province_id) values(118,'濰坊市',16); insert into zyx_city (city_id,city_name,province_id) values(119,'濟(jì)寧市',16); insert into zyx_city (city_id,city_name,province_id) values(120,'泰安市',16); insert into zyx_city (city_id,city_name,province_id) values(121,'威海市',16); insert into zyx_city (city_id,city_name,province_id) values(122,'日照市',16); insert into zyx_city (city_id,city_name,province_id) values(123,'萊蕪市',16); insert into zyx_city (city_id,city_name,province_id) values(124,'臨沂市',16); insert into zyx_city (city_id,city_name,province_id) values(125,'德州市',16); insert into zyx_city (city_id,city_name,province_id) values(126,'聊城市',16); insert into zyx_city (city_id,city_name,province_id) values(127,'濱州市',16); insert into zyx_city (city_id,city_name,province_id) values(128,'菏澤市',16);-- select * from zyx_city (city_id,city_name,province_id) where pid=16 order; by cid-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 17河南省 17個(gè)地級(jí)市 insert into zyx_city (city_id,city_name,province_id) values(129,'鄭州市',17); insert into zyx_city (city_id,city_name,province_id) values(130,'開封市',17); insert into zyx_city (city_id,city_name,province_id) values(131,'洛陽(yáng)市',17); insert into zyx_city (city_id,city_name,province_id) values(132,'平頂山市',17); insert into zyx_city (city_id,city_name,province_id) values(133,'安陽(yáng)市',17); insert into zyx_city (city_id,city_name,province_id) values(134,'鶴壁市',17); insert into zyx_city (city_id,city_name,province_id) values(135,'新鄉(xiāng)市',17); insert into zyx_city (city_id,city_name,province_id) values(136,'焦作市',17); insert into zyx_city (city_id,city_name,province_id) values(137,'濮陽(yáng)市',17); insert into zyx_city (city_id,city_name,province_id) values(138,'許昌市',17); insert into zyx_city (city_id,city_name,province_id) values(139,'漯河市',17); insert into zyx_city (city_id,city_name,province_id) values(140,'三門峽市',17); insert into zyx_city (city_id,city_name,province_id) values(141,'南陽(yáng)市',17); insert into zyx_city (city_id,city_name,province_id) values(142,'商丘市',17); insert into zyx_city (city_id,city_name,province_id) values(143,'信陽(yáng)市',17); insert into zyx_city (city_id,city_name,province_id) values(144,'周口市',17); insert into zyx_city (city_id,city_name,province_id) values(145,'駐馬店市',17); insert into zyx_city (city_id,city_name,province_id) values(146,'濟(jì)源市',17);-- select * from zyx_city (city_id,city_name,province_id) where pid=17 order by cid-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 18湖北省（截至2005年12月31日，全省轄13個(gè)地級(jí)單位（12個(gè)地級(jí)市、1個(gè)自治州）；102縣級(jí)單位（38個(gè)市轄區(qū)、24個(gè)縣級(jí)市、37個(gè)縣、2個(gè)自治縣、1個(gè)林區(qū)），共有1220個(gè)鄉(xiāng)級(jí)單位（277個(gè)街道、733個(gè)鎮(zhèn)、210個(gè)鄉(xiāng)）。） insert into zyx_city (city_id,city_name,province_id) values(147,'武漢市',18); insert into zyx_city (city_id,city_name,province_id) values(148,'黃石市',18); insert into zyx_city (city_id,city_name,province_id) values(149,'十堰市',18); insert into zyx_city (city_id,city_name,province_id) values(150,'荊州市',18); insert into zyx_city (city_id,city_name,province_id) values(151,'宜昌市',18); insert into zyx_city (city_id,city_name,province_id) values(152,'襄樊市',18); insert into zyx_city (city_id,city_name,province_id) values(153,'鄂州市',18); insert into zyx_city (city_id,city_name,province_id) values(154,'荊門市',18); insert into zyx_city (city_id,city_name,province_id) values(155,'孝感市',18); insert into zyx_city (city_id,city_name,province_id) values(156,'黃岡市',18); insert into zyx_city (city_id,city_name,province_id) values(157,'咸寧市',18); insert into zyx_city (city_id,city_name,province_id) values(158,'隨州市',18); insert into zyx_city (city_id,city_name,province_id) values(159,'仙桃市',18); insert into zyx_city (city_id,city_name,province_id) values(160,'天門市',18); insert into zyx_city (city_id,city_name,province_id) values(161,'潛江市',18); insert into zyx_city (city_id,city_name,province_id) values(162,'神農(nóng)架林區(qū)',18); insert into zyx_city (city_id,city_name,province_id) values(163,'恩施土家族苗族自治州',18);-- select * from zyx_city (city_id,city_name,province_id) where pid=18 order by cid-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 19湖南省（2005年轄：13個(gè)地級(jí)市、1個(gè)自治州；34個(gè)市轄區(qū)、16個(gè)縣級(jí)市、65個(gè)縣、7個(gè)自治縣。） insert into zyx_city (city_id,city_name,province_id) values(164,'長(zhǎng)沙市',19); insert into zyx_city (city_id,city_name,province_id) values(165,'株洲市',19); insert into zyx_city (city_id,city_name,province_id) values(166,'湘潭市',19); insert into zyx_city (city_id,city_name,province_id) values(167,'衡陽(yáng)市',19); insert into zyx_city (city_id,city_name,province_id) values(168,'邵陽(yáng)市',19); insert into zyx_city (city_id,city_name,province_id) values(169,'岳陽(yáng)市',19); insert into zyx_city (city_id,city_name,province_id) values(170,'常德市',19); insert into zyx_city (city_id,city_name,province_id) values(171,'張家界市',19); insert into zyx_city (city_id,city_name,province_id) values(172,'益陽(yáng)市',19); insert into zyx_city (city_id,city_name,province_id) values(173,'郴州市',19); insert into zyx_city (city_id,city_name,province_id) values(174,'永州市',19); insert into zyx_city (city_id,city_name,province_id) values(175,'懷化市',19); insert into zyx_city (city_id,city_name,province_id) values(176,'婁底市',19); insert into zyx_city (city_id,city_name,province_id) values(177,'湘西土家族苗族自治州',19);-- select * from zyx_city (city_id,city_name,province_id) where pid=19 order by cid-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 20廣東省（截至2005年12月31日，廣東省轄：21個(gè)地級(jí)市，54個(gè)市轄區(qū)、23個(gè)縣級(jí)市、41個(gè)縣、3個(gè)自治縣，429個(gè)街道辦事處、1145個(gè)鎮(zhèn)、4個(gè)鄉(xiāng)、7個(gè)民族鄉(xiāng)。） insert into zyx_city (city_id,city_name,province_id) values(178,'廣州市',20); insert into zyx_city (city_id,city_name,province_id) values(179,'深圳市',20); insert into zyx_city (city_id,city_name,province_id) values(180,'珠海市',20); insert into zyx_city (city_id,city_name,province_id) values(181,'汕頭市',20); insert into zyx_city (city_id,city_name,province_id) values(182,'韶關(guān)市',20); insert into zyx_city (city_id,city_name,province_id) values(183,'佛山市',20); insert into zyx_city (city_id,city_name,province_id) values(184,'江門市',20); insert into zyx_city (city_id,city_name,province_id) values(185,'湛江市',20); insert into zyx_city (city_id,city_name,province_id) values(186,'茂名市',20); insert into zyx_city (city_id,city_name,province_id) values(187,'肇慶市',20); insert into zyx_city (city_id,city_name,province_id) values(188,'惠州市',20); insert into zyx_city (city_id,city_name,province_id) values(189,'梅州市',20); insert into zyx_city (city_id,city_name,province_id) values(190,'汕尾市',20); insert into zyx_city (city_id,city_name,province_id) values(191,'河源市',20); insert into zyx_city (city_id,city_name,province_id) values(192,'陽(yáng)江市',20); insert into zyx_city (city_id,city_name,province_id) values(193,'清遠(yuǎn)市',20); insert into zyx_city (city_id,city_name,province_id) values(194,'東莞市',20); insert into zyx_city (city_id,city_name,province_id) values(195,'中山市',20); insert into zyx_city (city_id,city_name,province_id) values(196,'潮州市',20); insert into zyx_city (city_id,city_name,province_id) values(197,'揭陽(yáng)市',20); insert into zyx_city (city_id,city_name,province_id) values(198,'云浮市',20);-- select * from zyx_city (city_id,city_name,province_id) where pid=20 order by cid-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 21甘肅省 12個(gè)地級(jí)市、2個(gè)自治州 insert into zyx_city (city_id,city_name,province_id) values(199,'蘭州市',21); insert into zyx_city (city_id,city_name,province_id) values(200,'金昌市',21); insert into zyx_city (city_id,city_name,province_id) values(201,'白銀市',21); insert into zyx_city (city_id,city_name,province_id) values(202,'天水市',21); insert into zyx_city (city_id,city_name,province_id) values(203,'嘉峪關(guān)市',21); insert into zyx_city (city_id,city_name,province_id) values(204,'武威市',21); insert into zyx_city (city_id,city_name,province_id) values(205,'張掖市',21); insert into zyx_city (city_id,city_name,province_id) values(206,'平?jīng)鍪?#39;,21); insert into zyx_city (city_id,city_name,province_id) values(207,'酒泉市',21); insert into zyx_city (city_id,city_name,province_id) values(208,'慶陽(yáng)市',21); insert into zyx_city (city_id,city_name,province_id) values(209,'定西市',21); insert into zyx_city (city_id,city_name,province_id) values(210,'隴南市',21); insert into zyx_city (city_id,city_name,province_id) values(211,'臨夏回族自治州',21); insert into zyx_city (city_id,city_name,province_id) values(212,'甘南藏族自治州',21);-- select * from zyx_city (city_id,city_name,province_id) where pid=21 order by cid-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 22四川省18個(gè)地級(jí)市、3個(gè)自治州 insert into zyx_city (city_id,city_name,province_id) values(213,'成都市',22); insert into zyx_city (city_id,city_name,province_id) values(214,'自貢市',22); insert into zyx_city (city_id,city_name,province_id) values(215,'攀枝花市',22); insert into zyx_city (city_id,city_name,province_id) values(216,'瀘州市',22); insert into zyx_city (city_id,city_name,province_id) values(217,'德陽(yáng)市',22); insert into zyx_city (city_id,city_name,province_id) values(218,'綿陽(yáng)市',22); insert into zyx_city (city_id,city_name,province_id) values(219,'廣元市',22); insert into zyx_city (city_id,city_name,province_id) values(220,'遂寧市',22); insert into zyx_city (city_id,city_name,province_id) values(221,'內(nèi)江市',22); insert into zyx_city (city_id,city_name,province_id) values(222,'樂(lè)山市',22); insert into zyx_city (city_id,city_name,province_id) values(223,'南充市',22); insert into zyx_city (city_id,city_name,province_id) values(224,'眉山市',22); insert into zyx_city (city_id,city_name,province_id) values(225,'宜賓市',22); insert into zyx_city (city_id,city_name,province_id) values(226,'廣安市',22); insert into zyx_city (city_id,city_name,province_id) values(227,'達(dá)州市',22); insert into zyx_city (city_id,city_name,province_id) values(228,'雅安市',22); insert into zyx_city (city_id,city_name,province_id) values(229,'巴中市',22); insert into zyx_city (city_id,city_name,province_id) values(230,'資陽(yáng)市',22); insert into zyx_city (city_id,city_name,province_id) values(231,'阿壩藏族羌族自治州',22); insert into zyx_city (city_id,city_name,province_id) values(232,'甘孜藏族自治州',22); insert into zyx_city (city_id,city_name,province_id) values(233,'涼山彝族自治州',22);-- select * from zyx_city (city_id,city_name,province_id) where pid=22 order by cid;-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 23貴州省(2006年轄：4個(gè)地級(jí)市、2個(gè)地區(qū)、3個(gè)自治州；10個(gè)市轄區(qū)、9個(gè)縣級(jí)市、56個(gè)縣、11個(gè)自治縣、2個(gè)特區(qū)。) insert into zyx_city (city_id,city_name,province_id) values(234,'貴陽(yáng)市',23); insert into zyx_city (city_id,city_name,province_id) values(235,'六盤水市',23); insert into zyx_city (city_id,city_name,province_id) values(236,'遵義市',23); insert into zyx_city (city_id,city_name,province_id) values(237,'安順市',23); insert into zyx_city (city_id,city_name,province_id) values(238,'銅仁地區(qū)',23); insert into zyx_city (city_id,city_name,province_id) values(239,'畢節(jié)地區(qū)',23); insert into zyx_city (city_id,city_name,province_id) values(240,'黔西南布依族苗族自治州',23); insert into zyx_city (city_id,city_name,province_id) values(241,'黔東南苗族侗族自治州',23); insert into zyx_city (city_id,city_name,province_id) values(242,'黔南布依族苗族自治州',23);-- select * from zyx_city (city_id,city_name,province_id) where pid=23 order by cid;-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 24海南省全省有2個(gè)地級(jí)市，6個(gè)縣級(jí)市，4個(gè)縣，6個(gè)民族自治縣，4個(gè)市轄區(qū)，1個(gè)辦事處（西南中沙群島辦事處，縣級(jí)）。) insert into zyx_city (city_id,city_name,province_id) values(243,'海口市',24); insert into zyx_city (city_id,city_name,province_id) values(244,'三亞市',24); insert into zyx_city (city_id,city_name,province_id) values(245,'五指山市',24); insert into zyx_city (city_id,city_name,province_id) values(246,'瓊海市',24); insert into zyx_city (city_id,city_name,province_id) values(247,'儋州市',24); insert into zyx_city (city_id,city_name,province_id) values(248,'文昌市',24); insert into zyx_city (city_id,city_name,province_id) values(249,'萬(wàn)寧市',24); insert into zyx_city (city_id,city_name,province_id) values(250,'東方市',24); insert into zyx_city (city_id,city_name,province_id) values(251,'澄邁縣',24); insert into zyx_city (city_id,city_name,province_id) values(252,'定安縣',24); insert into zyx_city (city_id,city_name,province_id) values(253,'屯昌縣',24); insert into zyx_city (city_id,city_name,province_id) values(254,'臨高縣',24); insert into zyx_city (city_id,city_name,province_id) values(255,'白沙黎族自治縣',24); insert into zyx_city (city_id,city_name,province_id) values(256,'昌江黎族自治縣',24); insert into zyx_city (city_id,city_name,province_id) values(257,'樂(lè)東黎族自治縣',24); insert into zyx_city (city_id,city_name,province_id) values(258,'陵水黎族自治縣',24); insert into zyx_city (city_id,city_name,province_id) values(259,'保亭黎族苗族自治縣',24); insert into zyx_city (city_id,city_name,province_id) values(260,'瓊中黎族苗族自治縣',24);-- select * from zyx_city (city_id,city_name,province_id) where pid=24 order by cid;-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 25云南省(2006年轄：8個(gè)地級(jí)市、8個(gè)自治州；12個(gè)市轄區(qū)、9個(gè)縣級(jí)市、79個(gè)縣、29個(gè)自治縣。) insert into zyx_city (city_id,city_name,province_id) values(261,'昆明市',25); insert into zyx_city (city_id,city_name,province_id) values(262,'曲靖市',25); insert into zyx_city (city_id,city_name,province_id) values(263,'玉溪市',25); insert into zyx_city (city_id,city_name,province_id) values(264,'保山市',25); insert into zyx_city (city_id,city_name,province_id) values(265,'昭通市',25); insert into zyx_city (city_id,city_name,province_id) values(266,'麗江市',25); insert into zyx_city (city_id,city_name,province_id) values(267,'思茅市',25); insert into zyx_city (city_id,city_name,province_id) values(268,'臨滄市',25); insert into zyx_city (city_id,city_name,province_id) values(269,'文山壯族苗族自治州',25); insert into zyx_city (city_id,city_name,province_id) values(270,'紅河哈尼族彝族自治州',25); insert into zyx_city (city_id,city_name,province_id) values(271,'西雙版納傣族自治州',25); insert into zyx_city (city_id,city_name,province_id) values(272,'楚雄彝族自治州',25); insert into zyx_city (city_id,city_name,province_id) values(273,'大理白族自治州',25); insert into zyx_city (city_id,city_name,province_id) values(274,'德宏傣族景頗族自治州',25); insert into zyx_city (city_id,city_name,province_id) values(275,'怒江傈傈族自治州',25); insert into zyx_city (city_id,city_name,province_id) values(276,'迪慶藏族自治州',25);-- select * from zyx_city (city_id,city_name,province_id) where pid=25 order by cid;-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 26青海省(2006年轄：1個(gè)地級(jí)市、1個(gè)地區(qū)、6個(gè)自治州；4個(gè)市轄區(qū)、2個(gè)縣級(jí)市、30個(gè)縣、7個(gè)自治縣。) insert into zyx_city (city_id,city_name,province_id) values(277,'西寧市',26); insert into zyx_city (city_id,city_name,province_id) values(278,'海東地區(qū)',26); insert into zyx_city (city_id,city_name,province_id) values(279,'海北藏族自治州',26); insert into zyx_city (city_id,city_name,province_id) values(280,'黃南藏族自治州',26); insert into zyx_city (city_id,city_name,province_id) values(281,'海南藏族自治州',26); insert into zyx_city (city_id,city_name,province_id) values(282,'果洛藏族自治州',26); insert into zyx_city (city_id,city_name,province_id) values(283,'玉樹藏族自治州',26); insert into zyx_city (city_id,city_name,province_id) values(284,'海西蒙古族藏族自治州',26);-- select * from zyx_city (city_id,city_name,province_id) where pid=26 order by cid-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 27陜西省(2006年轄：10個(gè)地級(jí)市；24個(gè)市轄區(qū)、3個(gè)縣級(jí)市、80個(gè)縣。) insert into zyx_city (city_id,city_name,province_id) values(285,'西安市',27); insert into zyx_city (city_id,city_name,province_id) values(286,'銅川市',27); insert into zyx_city (city_id,city_name,province_id) values(287,'寶雞市',27); insert into zyx_city (city_id,city_name,province_id) values(288,'咸陽(yáng)市',27); insert into zyx_city (city_id,city_name,province_id) values(289,'渭南市',27); insert into zyx_city (city_id,city_name,province_id) values(290,'延安市',27); insert into zyx_city (city_id,city_name,province_id) values(291,'漢中市',27); insert into zyx_city (city_id,city_name,province_id) values(292,'榆林市',27); insert into zyx_city (city_id,city_name,province_id) values(293,'安康市',27); insert into zyx_city (city_id,city_name,province_id) values(294,'商洛市',27);-- select * from zyx_city (city_id,city_name,province_id) where pid=27 order by cid-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 28廣西壯族自治區(qū)(2005年轄：14個(gè)地級(jí)市；34個(gè)市轄區(qū)、7個(gè)縣級(jí)市、56個(gè)縣、12個(gè)自治縣。) insert into zyx_city (city_id,city_name,province_id) values(295,'南寧市',28); insert into zyx_city (city_id,city_name,province_id) values(296,'柳州市',28); insert into zyx_city (city_id,city_name,province_id) values(297,'桂林市',28); insert into zyx_city (city_id,city_name,province_id) values(298,'梧州市',28); insert into zyx_city (city_id,city_name,province_id) values(299,'北海市',28); insert into zyx_city (city_id,city_name,province_id) values(300,'防城港市',28); insert into zyx_city (city_id,city_name,province_id) values(301,'欽州市',28); insert into zyx_city (city_id,city_name,province_id) values(302,'貴港市',28); insert into zyx_city (city_id,city_name,province_id) values(303,'玉林市',28); insert into zyx_city (city_id,city_name,province_id) values(304,'百色市',28); insert into zyx_city (city_id,city_name,province_id) values(305,'賀州市',28); insert into zyx_city (city_id,city_name,province_id) values(306,'河池市',28); insert into zyx_city (city_id,city_name,province_id) values(307,'來(lái)賓市',28); insert into zyx_city (city_id,city_name,province_id) values(308,'崇左市',28);-- select * from zyx_city (city_id,city_name,province_id) where pid=28 order by cid-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 29西藏自治區(qū)(2005年轄：1個(gè)地級(jí)市、6個(gè)地區(qū)；1個(gè)市轄區(qū)、1個(gè)縣級(jí)市、71個(gè)縣。) insert into zyx_city (city_id,city_name,province_id) values(309,'拉薩市',29); insert into zyx_city (city_id,city_name,province_id) values(310,'那曲地區(qū)',29); insert into zyx_city (city_id,city_name,province_id) values(311,'昌都地區(qū)',29); insert into zyx_city (city_id,city_name,province_id) values(312,'山南地區(qū)',29); insert into zyx_city (city_id,city_name,province_id) values(313,'日喀則地區(qū)',29); insert into zyx_city (city_id,city_name,province_id) values(314,'阿里地區(qū)',29); insert into zyx_city (city_id,city_name,province_id) values(315,'林芝地區(qū)',29);-- select * from zyx_city (city_id,city_name,province_id) where pid=29 order by cid-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 30寧夏回族自治區(qū) insert into zyx_city (city_id,city_name,province_id) values(316,'銀川市',30); insert into zyx_city (city_id,city_name,province_id) values(317,'石嘴山市',30); insert into zyx_city (city_id,city_name,province_id) values(318,'吳忠市',30); insert into zyx_city (city_id,city_name,province_id) values(319,'固原市',30); insert into zyx_city (city_id,city_name,province_id) values(320,'中衛(wèi)市',30);-- select * from zyx_city (city_id,city_name,province_id) where pid=30 order by cid-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 31新疆維吾爾自治區(qū)(2005年轄：2個(gè)地級(jí)市、7個(gè)地區(qū)、5個(gè)自治州；11個(gè)市轄區(qū)、20個(gè)縣級(jí)市、62個(gè)縣、6個(gè)自治縣) insert into zyx_city (city_id,city_name,province_id) values(321,'烏魯木齊市',31); insert into zyx_city (city_id,city_name,province_id) values(322,'克拉瑪依市',31); insert into zyx_city (city_id,city_name,province_id) values(323,'石河子市　',31); insert into zyx_city (city_id,city_name,province_id) values(324,'阿拉爾市',31); insert into zyx_city (city_id,city_name,province_id) values(325,'圖木舒克市',31); insert into zyx_city (city_id,city_name,province_id) values(326,'五家渠市',31); insert into zyx_city (city_id,city_name,province_id) values(327,'吐魯番市',31); insert into zyx_city (city_id,city_name,province_id) values(328,'阿克蘇市',31); insert into zyx_city (city_id,city_name,province_id) values(329,'喀什市',31); insert into zyx_city (city_id,city_name,province_id) values(330,'哈密市',31); insert into zyx_city (city_id,city_name,province_id) values(331,'和田市',31); insert into zyx_city (city_id,city_name,province_id) values(332,'阿圖什市',31); insert into zyx_city (city_id,city_name,province_id) values(333,'庫(kù)爾勒市',31); insert into zyx_city (city_id,city_name,province_id) values(334,'昌吉市　',31); insert into zyx_city (city_id,city_name,province_id) values(335,'阜康市',31); insert into zyx_city (city_id,city_name,province_id) values(336,'米泉市',31); insert into zyx_city (city_id,city_name,province_id) values(337,'博樂(lè)市',31); insert into zyx_city (city_id,city_name,province_id) values(338,'伊寧市',31); insert into zyx_city (city_id,city_name,province_id) values(339,'奎屯市',31); insert into zyx_city (city_id,city_name,province_id) values(340,'塔城市',31); insert into zyx_city (city_id,city_name,province_id) values(341,'烏蘇市',31); insert into zyx_city (city_id,city_name,province_id) values(342,'阿勒泰市',31);-- select * from zyx_city (city_id,city_name,province_id) where pid=31 order by cid-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 32內(nèi)蒙古自治區(qū)(2006年，轄：9個(gè)地級(jí)市、3個(gè)盟；21個(gè)市轄區(qū)、11個(gè)縣級(jí)市、17個(gè)縣、49個(gè)旗、3個(gè)自治旗。) insert into zyx_city (city_id,city_name,province_id) values(343,'呼和浩特市',32); insert into zyx_city (city_id,city_name,province_id) values(344,'包頭市',32); insert into zyx_city (city_id,city_name,province_id) values(345,'烏海市',32); insert into zyx_city (city_id,city_name,province_id) values(346,'赤峰市',32); insert into zyx_city (city_id,city_name,province_id) values(347,'通遼市',32); insert into zyx_city (city_id,city_name,province_id) values(348,'鄂爾多斯市',32); insert into zyx_city (city_id,city_name,province_id) values(349,'呼倫貝爾市',32); insert into zyx_city (city_id,city_name,province_id) values(350,'巴彥淖爾市',32); insert into zyx_city (city_id,city_name,province_id) values(351,'烏蘭察布市',32); insert into zyx_city (city_id,city_name,province_id) values(352,'錫林郭勒盟',32); insert into zyx_city (city_id,city_name,province_id) values(353,'興安盟',32); insert into zyx_city (city_id,city_name,province_id) values(354,'阿拉善盟',32);-- select * from zyx_city (city_id,city_name,province_id) where pid=32 order by -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 33澳門特別行政區(qū) insert into zyx_city (city_id,city_name,province_id) values(355,'澳門特別行政區(qū)',33);-- select * from zyx_city (city_id,city_name,province_id) where pid=33 order by cid-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- 34香港特別行政區(qū) insert into zyx_city (city_id,city_name,province_id) values(356,'香港特別行政區(qū)',34);-- 7臺(tái)灣省(臺(tái)灣本島和澎湖共設(shè)7市、16縣，其中臺(tái)北市和高雄市為“院轄市”，直屬“行政院”，其余屬臺(tái)灣省；市下設(shè)區(qū)，縣下設(shè)市（縣轄市）、鎮(zhèn)、鄉(xiāng)，合稱區(qū)市鎮(zhèn)鄉(xiāng)。) insert into zyx_city (city_id,city_name,province_id) values(357,'臺(tái)北市',7); insert into zyx_city (city_id,city_name,province_id) values(358,'高雄市',7); insert into zyx_city (city_id,city_name,province_id) values(359,'基隆市',7); insert into zyx_city (city_id,city_name,province_id) values(360,'臺(tái)中市',7); insert into zyx_city (city_id,city_name,province_id) values(361,'臺(tái)南市',7); insert into zyx_city (city_id,city_name,province_id) values(362,'新竹市',7); insert into zyx_city (city_id,city_name,province_id) values(363,'嘉義市',7); insert into zyx_city (city_id,city_name,province_id) values(364,'臺(tái)北縣',7); insert into zyx_city (city_id,city_name,province_id) values(365,'宜蘭縣',7); insert into zyx_city (city_id,city_name,province_id) values(366,'桃園縣',7); insert into zyx_city (city_id,city_name,province_id) values(367,'新竹縣',7); insert into zyx_city (city_id,city_name,province_id) values(368,'苗栗縣',7); insert into zyx_city (city_id,city_name,province_id) values(369,'臺(tái)中縣',7); insert into zyx_city (city_id,city_name,province_id) values(370,'彰化縣',7); insert into zyx_city (city_id,city_name,province_id) values(371,'南投縣',7); insert into zyx_city (city_id,city_name,province_id) values(372,'云林縣',7); insert into zyx_city (city_id,city_name,province_id) values(373,'嘉義縣',7); insert into zyx_city (city_id,city_name,province_id) values(374,'臺(tái)南縣',7); insert into zyx_city (city_id,city_name,province_id) values(375,'高雄縣',7); insert into zyx_city (city_id,city_name,province_id) values(376,'屏東縣',7); insert into zyx_city (city_id,city_name,province_id) values(377,'澎湖縣',7); insert into zyx_city (city_id,city_name,province_id) values(378,'臺(tái)東縣',7); insert into zyx_city (city_id,city_name,province_id) values(379,'花蓮縣',7);

該處使用的url網(wǎng)絡(luò)請(qǐng)求的數(shù)據(jù)。

總結(jié)

以上是生活随笔為你收集整理的使用Navicat生成全国省份城市SQL数据库的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。