省市区县的sql语句——城市
/*
SQLyog v10.2
MySQL - 5.5.48 : Database - 省市县
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`省市县` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
USE `省市县`;
/*Table structure for table `city` */
DROP TABLE IF EXISTS `city`;
CREATE TABLE `city` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(6) COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`provincecode` varchar(6) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`,`provincecode`)
) ENGINE=InnoDB AUTO_INCREMENT=343 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `city` */
insert into `city`(`id`,`code`,`name`,`provincecode`) values (1,'110100','北京市','110000'),(2,'130100','石家庄市','130000'),(3,'130200','唐山市','130000'),(4,'130300','秦皇岛市','130000'),(5,'130400','邯郸市','130000'),(6,'130500','邢台市','130000'),(7,'130600','保定市','130000'),(8,'130700','张家口市','130000'),(9,'130800','承德市','130000'),(10,'130900','沧州市','130000'),(11,'131000','廊坊市','130000'),(12,'131100','衡水市','130000'),(13,'140100','太原市','140000'),(14,'140200','大同市','140000'),(15,'140300','阳泉市','140000'),(16,'140400','长治市','140000'),(17,'140500','晋城市','140000'),(18,'140600','朔州市','140000'),(19,'140700','晋中市','140000'),(20,'140800','运城市','140000'),(21,'140900','忻州市','140000'),(22,'141000','临汾市','140000'),(23,'141100','吕梁市','140000'),(24,'150100','呼和浩特市','150000'),(25,'150200','包头市','150000'),(26,'150300','乌海市','150000'),(27,'150400','赤峰市','150000'),(28,'150500','通辽市','150000'),(29,'150600','鄂尔多斯市','150000'),(30,'150700','呼伦贝尔市','150000'),(31,'150800','巴彦淖尔市','150000'),(32,'150900','乌兰察布市','150000'),(33,'152200','兴安盟','150000'),(34,'152500','锡林郭勒盟','150000'),(35,'152900','阿拉善盟','150000'),(36,'210100','沈阳市','210000'),(37,'210200','大连市','210000'),(38,'210300','鞍山市','210000'),(39,'210400','抚顺市','210000'),(40,'210500','本溪市','210000'),(41,'210600','丹东市','210000'),(42,'210700','锦州市','210000'),(43,'210800','营口市','210000'),(44,'210900','阜新市','210000'),(45,'211000','辽阳市','210000'),(46,'211100','盘锦市','210000'),(47,'211200','铁岭市','210000'),(48,'211300','朝阳市','210000'),(49,'211400','葫芦岛市','210000'),(50,'220100','长春市','220000'),(51,'220200','吉林市','220000'),(52,'220300','四平市','220000'),(53,'220400','辽源市','220000'),(54,'220500','通化市','220000'),(55,'220600','白山市','220000'),(56,'220700','松原市','220000'),(57,'220800','白城市','220000'),(58,'222400','延边朝鲜族自治州','220000'),(59,'230100','哈尔滨市','230000'),(60,'230200','齐齐哈尔市','230000'),(61,'230300','鸡西市','230000'),(62,'230400','鹤岗市','230000'),(63,'230500','双鸭山市','230000'),(64,'230600','大庆市','230000'),(65,'230700','伊春市','230000'),(66,'230800','佳木斯市','230000'),(67,'230900','七台河市','230000'),(68,'231000','牡丹江市','230000'),(69,'231100','黑河市','230000'),(70,'231200','绥化市','230000'),(71,'232700','大兴安岭地区','230000'),(72,'310100','市辖区','310000'),(73,'310200','县','310000'),(74,'320100','南京市','320000'),(75,'320200','无锡市','320000'),(76,'320300','徐州市','320000'),(77,'320400','常州市','320000'),(78,'320500','苏州市','320000'),(79,'320600','南通市','320000'),(80,'320700','连云港市','320000'),(81,'320800','淮安市','320000'),(82,'320900','盐城市','320000'),(83,'321000','扬州市','320000'),(84,'321100','镇江市','320000'),(85,'321200','泰州市','320000'),(86,'321300','宿迁市','320000'),(87,'330100','杭州市','330000'),(88,'330200','宁波市','330000'),(89,'330300','温州市','330000'),(90,'330400','嘉兴市','330000'),(91,'330500','湖州市','330000'),(92,'330600','绍兴市','330000'),(93,'330700','金华市','330000'),(94,'330800','衢州市','330000'),(95,'330900','舟山市','330000'),(96,'331000','台州市','330000'),(97,'331100','丽水市','330000'),(98,'340100','合肥市','340000'),(99,'340200','芜湖市','340000'),(100,'340300','蚌埠市','340000'),(101,'340400','淮南市','340000'),(102,'340500','马鞍山市','340000'),(103,'340600','淮北市','340000'),(104,'340700','铜陵市','340000'),(105,'340800','安庆市','340000'),(106,'341000','黄山市','340000'),(107,'341100','滁州市','340000'),(108,'341200','阜阳市','340000'),(109,'341300','宿州市','340000'),(110,'341400','巢湖市','340000'),(111,'341500','六安市','340000'),(112,'341600','亳州市','340000'),(113,'341700','池州市','340000'),(114,'341800','宣城市','340000'),(115,'350100','福州市','350000'),(116,'350200','厦门市','350000'),(117,'350300','莆田市','350000'),(118,'350400','三明市','350000'),(119,'350500','泉州市','350000'),(120,'350600','漳州市','350000'),(121,'350700','南平市','350000'),(122,'350800','龙岩市','350000'),(123,'350900','宁德市','350000'),(124,'360100','南昌市','360000'),(125,'360200','景德镇市','360000'),(126,'360300','萍乡市','360000'),(127,'360400','九江市','360000'),(128,'360500','新余市','360000'),(129,'360600','鹰潭市','360000'),(130,'360700','赣州市','360000'),(131,'360800','吉安市','360000'),(132,'360900','宜春市','360000'),(133,'361000','抚州市','360000'),(134,'361100','上饶市','360000'),(135,'370100','济南市','370000'),(136,'370200','青岛市','370000'),(137,'370300','淄博市','370000'),(138,'370400','枣庄市','370000'),(139,'370500','东营市','370000'),(140,'370600','烟台市','370000'),(141,'370700','潍坊市','370000'),(142,'370800','济宁市','370000'),(143,'370900','泰安市','370000'),(144,'371000','威海市','370000'),(145,'371100','日照市','370000'),(146,'371200','莱芜市','370000'),(147,'371300','临沂市','370000'),(148,'371400','德州市','370000'),(149,'371500','聊城市','370000'),(150,'371600','滨州市','370000'),(151,'371700','荷泽市','370000'),(152,'410100','郑州市','410000'),(153,'410200','开封市','410000'),(154,'410300','洛阳市','410000'),(155,'410400','平顶山市','410000'),(156,'410500','安阳市','410000'),(157,'410600','鹤壁市','410000'),(158,'410700','新乡市','410000'),(159,'410800','焦作市','410000'),(160,'410900','濮阳市','410000'),(161,'411000','许昌市','410000'),(162,'411100','漯河市','410000'),(163,'411200','三门峡市','410000'),(164,'411300','南阳市','410000'),(165,'411400','商丘市','410000'),(166,'411500','信阳市','410000'),(167,'411600','周口市','410000'),(168,'411700','驻马店市','410000'),(169,'420100','武汉市','420000'),(170,'420200','黄石市','420000'),(171,'420300','十堰市','420000'),(172,'420500','宜昌市','420000'),(173,'420600','襄樊市','420000'),(174,'420700','鄂州市','420000'),(175,'420800','荆门市','420000'),(176,'420900','孝感市','420000'),(177,'421000','荆州市','420000'),(178,'421100','黄冈市','420000'),(179,'421200','咸宁市','420000'),(180,'421300','随州市','420000'),(181,'422800','恩施土家族苗族自治州','420000'),(182,'429000','省直辖行政单位','420000'),(183,'430100','长沙市','430000'),(184,'430200','株洲市','430000'),(185,'430300','湘潭市','430000'),(186,'430400','衡阳市','430000'),(187,'430500','邵阳市','430000'),(188,'430600','岳阳市','430000'),(189,'430700','常德市','430000'),(190,'430800','张家界市','430000'),(191,'430900','益阳市','430000'),(192,'431000','郴州市','430000'),(193,'431100','永州市','430000'),(194,'431200','怀化市','430000'),(195,'431300','娄底市','430000'),(196,'433100','湘西土家族苗族自治州','430000'),(197,'440100','广州市','440000'),(198,'440200','韶关市','440000'),(199,'440300','深圳市','440000'),(200,'440400','珠海市','440000'),(201,'440500','汕头市','440000'),(202,'440600','佛山市','440000'),(203,'440700','江门市','440000'),(204,'440800','湛江市','440000'),(205,'440900','茂名市','440000'),(206,'441200','肇庆市','440000'),(207,'441300','惠州市','440000'),(208,'441400','梅州市','440000'),(209,'441500','汕尾市','440000'),(210,'441600','河源市','440000'),(211,'441700','阳江市','440000'),(212,'441800','清远市','440000'),(213,'441900','东莞市','440000'),(214,'442000','中山市','440000'),(215,'445100','潮州市','440000'),(216,'445200','揭阳市','440000'),(217,'445300','云浮市','440000'),(218,'450100','南宁市','450000'),(219,'450200','柳州市','450000'),(220,'450300','桂林市','450000'),(221,'450400','梧州市','450000'),(222,'450500','北海市','450000'),(223,'450600','防城港市','450000'),(224,'450700','钦州市','450000'),(225,'450800','贵港市','450000'),(226,'450900','玉林市','450000'),(227,'451000','百色市','450000'),(228,'451100','贺州市','450000'),(229,'451200','河池市','450000'),(230,'451300','来宾市','450000'),(231,'451400','崇左市','450000'),(232,'460100','海口市','460000'),(233,'460200','三亚市','460000'),(234,'469000','省直辖县级行政单位','460000'),(235,'500100','市辖区','500000'),(236,'500200','县','500000'),(237,'500300','市','500000'),(238,'510100','成都市','510000'),(239,'510300','自贡市','510000'),(240,'510400','攀枝花市','510000'),(241,'510500','泸州市','510000'),(242,'510600','德阳市','510000'),(243,'510700','绵阳市','510000'),(244,'510800','广元市','510000'),(245,'510900','遂宁市','510000'),(246,'511000','内江市','510000'),(247,'511100','乐山市','510000'),(248,'511300','南充市','510000'),(249,'511400','眉山市','510000'),(250,'511500','宜宾市','510000'),(251,'511600','广安市','510000'),(252,'511700','达州市','510000'),(253,'511800','雅安市','510000'),(254,'511900','巴中市','510000'),(255,'512000','资阳市','510000'),(256,'513200','阿坝藏族羌族自治州','510000'),(257,'513300','甘孜藏族自治州','510000'),(258,'513400','凉山彝族自治州','510000'),(259,'520100','贵阳市','520000'),(260,'520200','六盘水市','520000'),(261,'520300','遵义市','520000'),(262,'520400','安顺市','520000'),(263,'522200','铜仁地区','520000'),(264,'522300','黔西南布依族苗族自治州','520000'),(265,'522400','毕节地区','520000'),(266,'522600','黔东南苗族侗族自治州','520000'),(267,'522700','黔南布依族苗族自治州','520000'),(268,'530100','昆明市','530000'),(269,'530300','曲靖市','530000'),(270,'530400','玉溪市','530000'),(271,'530500','保山市','530000'),(272,'530600','昭通市','530000'),(273,'530700','丽江市','530000'),(274,'530800','思茅市','530000'),(275,'530900','临沧市','530000'),(276,'532300','楚雄彝族自治州','530000'),(277,'532500','红河哈尼族彝族自治州','530000'),(278,'532600','文山壮族苗族自治州','530000'),(279,'532800','西双版纳傣族自治州','530000'),(280,'532900','大理白族自治州','530000'),(281,'533100','德宏傣族景颇族自治州','530000'),(282,'533300','怒江傈僳族自治州','530000'),(283,'533400','迪庆藏族自治州','530000'),(284,'540100','拉萨市','540000'),(285,'542100','昌都地区','540000'),(286,'542200','山南地区','540000'),(287,'542300','日喀则地区','540000'),(288,'542400','那曲地区','540000'),(289,'542500','阿里地区','540000'),(290,'542600','林芝地区','540000'),(291,'610100','西安市','610000'),(292,'610200','铜川市','610000'),(293,'610300','宝鸡市','610000'),(294,'610400','咸阳市','610000'),(295,'610500','渭南市','610000'),(296,'610600','延安市','610000'),(297,'610700','汉中市','610000'),(298,'610800','榆林市','610000'),(299,'610900','安康市','610000'),(300,'611000','商洛市','610000'),(301,'620100','兰州市','620000'),(302,'620200','嘉峪关市','620000'),(303,'620300','金昌市','620000'),(304,'620400','白银市','620000'),(305,'620500','天水市','620000'),(306,'620600','武威市','620000'),(307,'620700','张掖市','620000'),(308,'620800','平凉市','620000'),(309,'620900','酒泉市','620000'),(310,'621000','庆阳市','620000'),(311,'621100','定西市','620000'),(312,'621200','陇南市','620000'),(313,'622900','临夏回族自治州','620000'),(314,'623000','甘南藏族自治州','620000'),(315,'630100','西宁市','630000'),(316,'632100','海东地区','630000'),(317,'632200','海北藏族自治州','630000'),(318,'632300','黄南藏族自治州','630000'),(319,'632500','海南藏族自治州','630000'),(320,'632600','果洛藏族自治州','630000'),(321,'632700','玉树藏族自治州','630000'),(322,'632800','海西蒙古族藏族自治州','630000'),(323,'640100','银川市','640000'),(324,'640200','石嘴山市','640000'),(325,'640300','吴忠市','640000'),(326,'640400','固原市','640000'),(327,'640500','中卫市','640000'),(328,'650100','乌鲁木齐市','650000'),(329,'650200','克拉玛依市','650000'),(330,'652100','吐鲁番地区','650000'),(331,'652200','哈密地区','650000'),(332,'652300','昌吉回族自治州','650000'),(333,'652700','博尔塔拉蒙古自治州','650000'),(334,'652800','巴音郭楞蒙古自治州','650000'),(335,'652900','阿克苏地区','650000'),(336,'653000','克孜勒苏柯尔克孜自治州','650000'),(337,'653100','喀什地区','650000'),(338,'653200','和田地区','650000'),(339,'654000','伊犁哈萨克自治州','650000'),(340,'654200','塔城地区','650000'),(341,'654300','阿勒泰地区','650000'),(342,'659000','省直辖行政单位','650000');
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;