首页 > 代码库 > 区号数据库

区号数据库

  由于最近用到省市区号查询,但是在网上搜索很长时间,没有现成的数据库,只有码表,无奈之下,只能下载个码表,写个小程序跑出来个所需码表库。现帖下,希望节省下有相同需求的人的时间。

insert into t_city(id,code,name,pcode)values(1,‘0100‘,‘北京市‘,‘0‘);
insert into t_city(id,code,name,pcode)values(2,‘0220‘,‘天津市‘,‘0‘);
insert into t_city(id,code,name,pcode)values(3,‘0311‘,‘河北省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(4,‘0351‘,‘山西省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(5,‘0471‘,‘内蒙古自治区‘,‘0‘);
insert into t_city(id,code,name,pcode)values(6,‘0240‘,‘辽宁省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(7,‘0431‘,‘吉林省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(8,‘0451‘,‘黑龙江省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(9,‘0210‘,‘上海市‘,‘0‘);
insert into t_city(id,code,name,pcode)values(10,‘0250‘,‘江苏省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(11,‘0571‘,‘浙江省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(12,‘0551‘,‘安徽省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(13,‘0591‘,‘福建省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(14,‘0791‘,‘江西省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(15,‘0531‘,‘山东省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(16,‘0371‘,‘河南省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(17,‘0270‘,‘湖北省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(18,‘0200‘,‘广东省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(19,‘0771‘,‘广西省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(20,‘0898‘,‘海南省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(21,‘0230‘,‘重庆市‘,‘0‘);
insert into t_city(id,code,name,pcode)values(22,‘0280‘,‘四川省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(23,‘0851‘,‘贵州省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(24,‘0871‘,‘云南省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(25,‘0891‘,‘西藏自治区‘,‘0‘);
insert into t_city(id,code,name,pcode)values(26,‘0290‘,‘陕西省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(27,‘0931‘,‘甘肃省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(28,‘0731‘,‘湖南省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(29,‘0971‘,‘青海省‘,‘0‘);
insert into t_city(id,code,name,pcode)values(30,‘0951‘,‘宁夏回族自治区‘,‘0‘);
insert into t_city(id,code,name,pcode)values(31,‘0991‘,‘新疆维吾尔自治区‘,‘0‘);
insert into t_city(id,code,name,pcode)values(32,‘100‘,‘北京‘,‘0100‘);
insert into t_city(id,code,name,pcode)values(33,‘220‘,‘天津‘,‘0220‘);
insert into t_city(id,code,name,pcode)values(34,‘311‘,‘石家庄‘,‘0311‘);
insert into t_city(id,code,name,pcode)values(35,‘313‘,‘张家口‘,‘0311‘);
insert into t_city(id,code,name,pcode)values(36,‘314‘,‘承德‘,‘0311‘);
insert into t_city(id,code,name,pcode)values(37,‘335‘,‘秦皇岛‘,‘0311‘);
insert into t_city(id,code,name,pcode)values(38,‘315‘,‘唐山‘,‘0311‘);
insert into t_city(id,code,name,pcode)values(39,‘316‘,‘廊坊‘,‘0311‘);
insert into t_city(id,code,name,pcode)values(40,‘312‘,‘保定‘,‘0311‘);
insert into t_city(id,code,name,pcode)values(41,‘317‘,‘沧州‘,‘0311‘);
insert into t_city(id,code,name,pcode)values(42,‘318‘,‘衡水‘,‘0311‘);
insert into t_city(id,code,name,pcode)values(43,‘319‘,‘邢台‘,‘0311‘);
insert into t_city(id,code,name,pcode)values(44,‘310‘,‘邯郸‘,‘0311‘);
insert into t_city(id,code,name,pcode)values(45,‘351‘,‘太原‘,‘0351‘);
insert into t_city(id,code,name,pcode)values(46,‘352‘,‘大同‘,‘0351‘);
insert into t_city(id,code,name,pcode)values(47,‘349‘,‘朔州‘,‘0351‘);
insert into t_city(id,code,name,pcode)values(48,‘353‘,‘阳泉‘,‘0351‘);
insert into t_city(id,code,name,pcode)values(49,‘355‘,‘长治‘,‘0351‘);
insert into t_city(id,code,name,pcode)values(50,‘356‘,‘晋城‘,‘0351‘);
insert into t_city(id,code,name,pcode)values(51,‘350‘,‘忻州‘,‘0351‘);
insert into t_city(id,code,name,pcode)values(52,‘358‘,‘离石‘,‘0351‘);
insert into t_city(id,code,name,pcode)values(53,‘354‘,‘榆次‘,‘0351‘);
insert into t_city(id,code,name,pcode)values(54,‘357‘,‘临汾‘,‘0351‘);
insert into t_city(id,code,name,pcode)values(55,‘359‘,‘运城‘,‘0351‘);
insert into t_city(id,code,name,pcode)values(56,‘471‘,‘呼和浩特‘,‘0471‘);
insert into t_city(id,code,name,pcode)values(57,‘472‘,‘包头‘,‘0471‘);
insert into t_city(id,code,name,pcode)values(58,‘473‘,‘乌海‘,‘0471‘);
insert into t_city(id,code,name,pcode)values(59,‘476‘,‘赤峰‘,‘0471‘);
insert into t_city(id,code,name,pcode)values(60,‘470‘,‘海拉尔‘,‘0471‘);
insert into t_city(id,code,name,pcode)values(61,‘482‘,‘乌兰浩特‘,‘0471‘);
insert into t_city(id,code,name,pcode)values(62,‘475‘,‘通辽‘,‘0471‘);
insert into t_city(id,code,name,pcode)values(63,‘479‘,‘锡林浩特‘,‘0471‘);
insert into t_city(id,code,name,pcode)values(64,‘474‘,‘集宁‘,‘0471‘);
insert into t_city(id,code,name,pcode)values(65,‘477‘,‘东胜‘,‘0471‘);
insert into t_city(id,code,name,pcode)values(66,‘478‘,‘临河‘,‘0471‘);
insert into t_city(id,code,name,pcode)values(67,‘483‘,‘阿拉善左旗‘,‘0471‘);
insert into t_city(id,code,name,pcode)values(68,‘240‘,‘沈阳‘,‘0240‘);
insert into t_city(id,code,name,pcode)values(69,‘421‘,‘朝阳‘,‘0240‘);
insert into t_city(id,code,name,pcode)values(70,‘418‘,‘阜新‘,‘0240‘);
insert into t_city(id,code,name,pcode)values(71,‘410‘,‘铁岭‘,‘0240‘);
insert into t_city(id,code,name,pcode)values(72,‘413‘,‘抚顺‘,‘0240‘);
insert into t_city(id,code,name,pcode)values(73,‘414‘,‘本溪‘,‘0240‘);
insert into t_city(id,code,name,pcode)values(74,‘419‘,‘辽阳‘,‘0240‘);
insert into t_city(id,code,name,pcode)values(75,‘412‘,‘鞍山‘,‘0240‘);
insert into t_city(id,code,name,pcode)values(76,‘415‘,‘丹东‘,‘0240‘);
insert into t_city(id,code,name,pcode)values(77,‘411‘,‘大连‘,‘0240‘);
insert into t_city(id,code,name,pcode)values(78,‘417‘,‘营口‘,‘0240‘);
insert into t_city(id,code,name,pcode)values(79,‘427‘,‘盘锦‘,‘0240‘);
insert into t_city(id,code,name,pcode)values(80,‘416‘,‘锦州‘,‘0240‘);
insert into t_city(id,code,name,pcode)values(81,‘429‘,‘葫芦岛‘,‘0240‘);
insert into t_city(id,code,name,pcode)values(82,‘431‘,‘长春‘,‘0431‘);
insert into t_city(id,code,name,pcode)values(83,‘436‘,‘白城‘,‘0431‘);
insert into t_city(id,code,name,pcode)values(84,‘438‘,‘松原‘,‘0431‘);
insert into t_city(id,code,name,pcode)values(85,‘432‘,‘吉林‘,‘0431‘);
insert into t_city(id,code,name,pcode)values(86,‘434‘,‘四平‘,‘0431‘);
insert into t_city(id,code,name,pcode)values(87,‘437‘,‘辽源‘,‘0431‘);
insert into t_city(id,code,name,pcode)values(88,‘435‘,‘通化‘,‘0431‘);
insert into t_city(id,code,name,pcode)values(89,‘439‘,‘白山‘,‘0431‘);
insert into t_city(id,code,name,pcode)values(90,‘433‘,‘延吉‘,‘0431‘);
insert into t_city(id,code,name,pcode)values(91,‘451‘,‘哈尔滨‘,‘0451‘);
insert into t_city(id,code,name,pcode)values(92,‘452‘,‘齐齐哈尔‘,‘0451‘);
insert into t_city(id,code,name,pcode)values(93,‘456‘,‘黑河‘,‘0451‘);
insert into t_city(id,code,name,pcode)values(94,‘459‘,‘大庆‘,‘0451‘);
insert into t_city(id,code,name,pcode)values(95,‘458‘,‘伊春‘,‘0451‘);
insert into t_city(id,code,name,pcode)values(96,‘468‘,‘鹤岗‘,‘0451‘);
insert into t_city(id,code,name,pcode)values(97,‘454‘,‘佳木斯‘,‘0451‘);
insert into t_city(id,code,name,pcode)values(98,‘469‘,‘双鸭山‘,‘0451‘);
insert into t_city(id,code,name,pcode)values(99,‘464‘,‘七台河‘,‘0451‘);
insert into t_city(id,code,name,pcode)values(100,‘467‘,‘鸡西‘,‘0451‘);
insert into t_city(id,code,name,pcode)values(101,‘453‘,‘牡丹江‘,‘0451‘);
insert into t_city(id,code,name,pcode)values(102,‘455‘,‘绥化‘,‘0451‘);
insert into t_city(id,code,name,pcode)values(103,‘457‘,‘加格达奇‘,‘0451‘);
insert into t_city(id,code,name,pcode)values(104,‘210‘,‘上海‘,‘0210‘);
insert into t_city(id,code,name,pcode)values(105,‘250‘,‘南京‘,‘0250‘);
insert into t_city(id,code,name,pcode)values(106,‘516‘,‘徐州‘,‘0250‘);
insert into t_city(id,code,name,pcode)values(107,‘518‘,‘连云港‘,‘0250‘);
insert into t_city(id,code,name,pcode)values(108,‘527‘,‘宿迁‘,‘0250‘);
insert into t_city(id,code,name,pcode)values(109,‘517‘,‘淮阴‘,‘0250‘);
insert into t_city(id,code,name,pcode)values(110,‘515‘,‘盐城‘,‘0250‘);
insert into t_city(id,code,name,pcode)values(111,‘514‘,‘扬州‘,‘0250‘);
insert into t_city(id,code,name,pcode)values(112,‘523‘,‘泰州‘,‘0250‘);
insert into t_city(id,code,name,pcode)values(113,‘513‘,‘南通‘,‘0250‘);
insert into t_city(id,code,name,pcode)values(114,‘511‘,‘镇江‘,‘0250‘);
insert into t_city(id,code,name,pcode)values(115,‘519‘,‘常州‘,‘0250‘);
insert into t_city(id,code,name,pcode)values(116,‘510‘,‘无锡‘,‘0250‘);
insert into t_city(id,code,name,pcode)values(117,‘512‘,‘苏州‘,‘0250‘);
insert into t_city(id,code,name,pcode)values(118,‘571‘,‘杭州‘,‘0571‘);
insert into t_city(id,code,name,pcode)values(119,‘572‘,‘湖州‘,‘0571‘);
insert into t_city(id,code,name,pcode)values(120,‘573‘,‘嘉兴‘,‘0571‘);
insert into t_city(id,code,name,pcode)values(121,‘580‘,‘舟山‘,‘0571‘);
insert into t_city(id,code,name,pcode)values(122,‘574‘,‘宁波‘,‘0571‘);
insert into t_city(id,code,name,pcode)values(123,‘575‘,‘绍兴‘,‘0571‘);
insert into t_city(id,code,name,pcode)values(124,‘579‘,‘金华‘,‘0571‘);
insert into t_city(id,code,name,pcode)values(125,‘576‘,‘台州‘,‘0571‘);
insert into t_city(id,code,name,pcode)values(126,‘577‘,‘温州‘,‘0571‘);
insert into t_city(id,code,name,pcode)values(127,‘578‘,‘丽水‘,‘0571‘);
insert into t_city(id,code,name,pcode)values(128,‘551‘,‘合肥‘,‘0551‘);
insert into t_city(id,code,name,pcode)values(129,‘557‘,‘宿州‘,‘0551‘);
insert into t_city(id,code,name,pcode)values(130,‘561‘,‘淮北‘,‘0551‘);
insert into t_city(id,code,name,pcode)values(131,‘558‘,‘阜阳‘,‘0551‘);
insert into t_city(id,code,name,pcode)values(132,‘552‘,‘蚌埠‘,‘0551‘);
insert into t_city(id,code,name,pcode)values(133,‘554‘,‘淮南‘,‘0551‘);
insert into t_city(id,code,name,pcode)values(134,‘550‘,‘滁州‘,‘0551‘);
insert into t_city(id,code,name,pcode)values(135,‘555‘,‘马鞍山‘,‘0551‘);
insert into t_city(id,code,name,pcode)values(136,‘553‘,‘芜湖‘,‘0551‘);
insert into t_city(id,code,name,pcode)values(137,‘562‘,‘铜陵‘,‘0551‘);
insert into t_city(id,code,name,pcode)values(138,‘556‘,‘安庆‘,‘0551‘);
insert into t_city(id,code,name,pcode)values(139,‘559‘,‘黄山‘,‘0551‘);
insert into t_city(id,code,name,pcode)values(140,‘564‘,‘六安‘,‘0551‘);
insert into t_city(id,code,name,pcode)values(141,‘565‘,‘巢湖‘,‘0551‘);
insert into t_city(id,code,name,pcode)values(142,‘566‘,‘贵池‘,‘0551‘);
insert into t_city(id,code,name,pcode)values(143,‘563‘,‘宣州‘,‘0551‘);
insert into t_city(id,code,name,pcode)values(144,‘591‘,‘福州‘,‘0591‘);
insert into t_city(id,code,name,pcode)values(145,‘599‘,‘南平‘,‘0591‘);
insert into t_city(id,code,name,pcode)values(146,‘598‘,‘三明‘,‘0591‘);
insert into t_city(id,code,name,pcode)values(147,‘594‘,‘莆田‘,‘0591‘);
insert into t_city(id,code,name,pcode)values(148,‘595‘,‘泉州‘,‘0591‘);
insert into t_city(id,code,name,pcode)values(149,‘592‘,‘厦门‘,‘0591‘);
insert into t_city(id,code,name,pcode)values(150,‘596‘,‘漳州‘,‘0591‘);
insert into t_city(id,code,name,pcode)values(151,‘597‘,‘龙岩‘,‘0591‘);
insert into t_city(id,code,name,pcode)values(152,‘593‘,‘宁德‘,‘0591‘);
insert into t_city(id,code,name,pcode)values(153,‘791‘,‘南昌‘,‘0791‘);
insert into t_city(id,code,name,pcode)values(154,‘792‘,‘九江‘,‘0791‘);
insert into t_city(id,code,name,pcode)values(155,‘798‘,‘景德镇‘,‘0791‘);
insert into t_city(id,code,name,pcode)values(156,‘710‘,‘鹰潭‘,‘0791‘);
insert into t_city(id,code,name,pcode)values(157,‘790‘,‘新余‘,‘0791‘);
insert into t_city(id,code,name,pcode)values(158,‘799‘,‘萍乡‘,‘0791‘);
insert into t_city(id,code,name,pcode)values(159,‘797‘,‘赣州‘,‘0791‘);
insert into t_city(id,code,name,pcode)values(160,‘793‘,‘上饶‘,‘0791‘);
insert into t_city(id,code,name,pcode)values(161,‘794‘,‘临川‘,‘0791‘);
insert into t_city(id,code,name,pcode)values(162,‘795‘,‘宜春‘,‘0791‘);
insert into t_city(id,code,name,pcode)values(163,‘796‘,‘吉安‘,‘0791‘);
insert into t_city(id,code,name,pcode)values(164,‘531‘,‘济南‘,‘0531‘);
insert into t_city(id,code,name,pcode)values(165,‘635‘,‘聊城‘,‘0531‘);
insert into t_city(id,code,name,pcode)values(166,‘534‘,‘德州‘,‘0531‘);
insert into t_city(id,code,name,pcode)values(167,‘546‘,‘东营‘,‘0531‘);
insert into t_city(id,code,name,pcode)values(168,‘533‘,‘淄博‘,‘0531‘);
insert into t_city(id,code,name,pcode)values(169,‘536‘,‘潍坊‘,‘0531‘);
insert into t_city(id,code,name,pcode)values(170,‘535‘,‘烟台‘,‘0531‘);
insert into t_city(id,code,name,pcode)values(171,‘631‘,‘威海‘,‘0531‘);
insert into t_city(id,code,name,pcode)values(172,‘532‘,‘青岛‘,‘0531‘);
insert into t_city(id,code,name,pcode)values(173,‘633‘,‘日照‘,‘0531‘);
insert into t_city(id,code,name,pcode)values(174,‘539‘,‘临沂‘,‘0531‘);
insert into t_city(id,code,name,pcode)values(175,‘632‘,‘枣庄‘,‘0531‘);
insert into t_city(id,code,name,pcode)values(176,‘537‘,‘济宁‘,‘0531‘);
insert into t_city(id,code,name,pcode)values(177,‘538‘,‘泰安‘,‘0531‘);
insert into t_city(id,code,name,pcode)values(178,‘634‘,‘莱芜‘,‘0531‘);
insert into t_city(id,code,name,pcode)values(179,‘543‘,‘滨州‘,‘0531‘);
insert into t_city(id,code,name,pcode)values(180,‘530‘,‘菏泽‘,‘0531‘);
insert into t_city(id,code,name,pcode)values(181,‘371‘,‘郑州‘,‘0371‘);
insert into t_city(id,code,name,pcode)values(182,‘398‘,‘三门峡‘,‘0371‘);
insert into t_city(id,code,name,pcode)values(183,‘379‘,‘洛阳‘,‘0371‘);
insert into t_city(id,code,name,pcode)values(184,‘391‘,‘焦作‘,‘0371‘);
insert into t_city(id,code,name,pcode)values(185,‘373‘,‘新乡‘,‘0371‘);
insert into t_city(id,code,name,pcode)values(186,‘392‘,‘鹤壁‘,‘0371‘);
insert into t_city(id,code,name,pcode)values(187,‘372‘,‘安阳‘,‘0371‘);
insert into t_city(id,code,name,pcode)values(188,‘393‘,‘濮阳‘,‘0371‘);
insert into t_city(id,code,name,pcode)values(189,‘378‘,‘开封‘,‘0371‘);
insert into t_city(id,code,name,pcode)values(190,‘370‘,‘商丘‘,‘0371‘);
insert into t_city(id,code,name,pcode)values(191,‘374‘,‘许昌‘,‘0371‘);
insert into t_city(id,code,name,pcode)values(192,‘395‘,‘漯河‘,‘0371‘);
insert into t_city(id,code,name,pcode)values(193,‘375‘,‘平顶山‘,‘0371‘);
insert into t_city(id,code,name,pcode)values(194,‘377‘,‘南阳‘,‘0371‘);
insert into t_city(id,code,name,pcode)values(195,‘376‘,‘信阳‘,‘0371‘);
insert into t_city(id,code,name,pcode)values(196,‘394‘,‘周口‘,‘0371‘);
insert into t_city(id,code,name,pcode)values(197,‘396‘,‘驻马店‘,‘0371‘);
insert into t_city(id,code,name,pcode)values(198,‘270‘,‘武汉‘,‘0270‘);
insert into t_city(id,code,name,pcode)values(199,‘719‘,‘十堰‘,‘0270‘);
insert into t_city(id,code,name,pcode)values(200,‘710‘,‘襄樊‘,‘0270‘);
insert into t_city(id,code,name,pcode)values(201,‘724‘,‘荆门‘,‘0270‘);
insert into t_city(id,code,name,pcode)values(202,‘712‘,‘孝感‘,‘0270‘);
insert into t_city(id,code,name,pcode)values(203,‘713‘,‘黄冈‘,‘0270‘);
insert into t_city(id,code,name,pcode)values(204,‘711‘,‘鄂州‘,‘0270‘);
insert into t_city(id,code,name,pcode)values(205,‘714‘,‘黄石‘,‘0270‘);
insert into t_city(id,code,name,pcode)values(206,‘715‘,‘咸宁‘,‘0270‘);
insert into t_city(id,code,name,pcode)values(207,‘716‘,‘荆州‘,‘0270‘);
insert into t_city(id,code,name,pcode)values(208,‘717‘,‘宜昌‘,‘0270‘);
insert into t_city(id,code,name,pcode)values(209,‘718‘,‘恩施‘,‘0270‘);
insert into t_city(id,code,name,pcode)values(210,‘200‘,‘广州‘,‘0200‘);
insert into t_city(id,code,name,pcode)values(211,‘763‘,‘清远‘,‘0200‘);
insert into t_city(id,code,name,pcode)values(212,‘751‘,‘韶关‘,‘0200‘);
insert into t_city(id,code,name,pcode)values(213,‘762‘,‘河源‘,‘0200‘);
insert into t_city(id,code,name,pcode)values(214,‘753‘,‘梅州‘,‘0200‘);
insert into t_city(id,code,name,pcode)values(215,‘768‘,‘潮州‘,‘0200‘);
insert into t_city(id,code,name,pcode)values(216,‘754‘,‘汕头‘,‘0200‘);
insert into t_city(id,code,name,pcode)values(217,‘663‘,‘揭阳‘,‘0200‘);
insert into t_city(id,code,name,pcode)values(218,‘660‘,‘汕尾‘,‘0200‘);
insert into t_city(id,code,name,pcode)values(219,‘752‘,‘惠州‘,‘0200‘);
insert into t_city(id,code,name,pcode)values(220,‘769‘,‘东莞‘,‘0200‘);
insert into t_city(id,code,name,pcode)values(221,‘755‘,‘深圳‘,‘0200‘);
insert into t_city(id,code,name,pcode)values(222,‘756‘,‘珠海‘,‘0200‘);
insert into t_city(id,code,name,pcode)values(223,‘760‘,‘中山‘,‘0200‘);
insert into t_city(id,code,name,pcode)values(224,‘750‘,‘江门‘,‘0200‘);
insert into t_city(id,code,name,pcode)values(225,‘757‘,‘佛山‘,‘0200‘);
insert into t_city(id,code,name,pcode)values(226,‘758‘,‘肇庆‘,‘0200‘);
insert into t_city(id,code,name,pcode)values(227,‘766‘,‘云浮‘,‘0200‘);
insert into t_city(id,code,name,pcode)values(228,‘662‘,‘阳江‘,‘0200‘);
insert into t_city(id,code,name,pcode)values(229,‘668‘,‘茂名‘,‘0200‘);
insert into t_city(id,code,name,pcode)values(230,‘759‘,‘湛江‘,‘0200‘);
insert into t_city(id,code,name,pcode)values(231,‘771‘,‘南宁‘,‘0771‘);
insert into t_city(id,code,name,pcode)values(232,‘773‘,‘桂林‘,‘0771‘);
insert into t_city(id,code,name,pcode)values(233,‘774‘,‘梧州‘,‘0771‘);
insert into t_city(id,code,name,pcode)values(234,‘775‘,‘玉林‘,‘0771‘);
insert into t_city(id,code,name,pcode)values(235,‘777‘,‘钦州‘,‘0771‘);
insert into t_city(id,code,name,pcode)values(236,‘779‘,‘北海‘,‘0771‘);
insert into t_city(id,code,name,pcode)values(237,‘770‘,‘防城港‘,‘0771‘);
insert into t_city(id,code,name,pcode)values(238,‘776‘,‘百色‘,‘0771‘);
insert into t_city(id,code,name,pcode)values(239,‘778‘,‘河池‘,‘0771‘);
insert into t_city(id,code,name,pcode)values(240,‘772‘,‘柳州‘,‘0771‘);
insert into t_city(id,code,name,pcode)values(241,‘898‘,‘海口‘,‘0898‘);
insert into t_city(id,code,name,pcode)values(242,‘899‘,‘三亚‘,‘0898‘);
insert into t_city(id,code,name,pcode)values(243,‘890‘,‘儋州‘,‘0898‘);
insert into t_city(id,code,name,pcode)values(244,‘230‘,‘重庆‘,‘0230‘);
insert into t_city(id,code,name,pcode)values(245,‘829‘,‘黔江‘,‘0230‘);
insert into t_city(id,code,name,pcode)values(246,‘280‘,‘成都‘,‘0280‘);
insert into t_city(id,code,name,pcode)values(247,‘839‘,‘广元‘,‘0280‘);
insert into t_city(id,code,name,pcode)values(248,‘816‘,‘绵阳‘,‘0280‘);
insert into t_city(id,code,name,pcode)values(249,‘838‘,‘德阳‘,‘0280‘);
insert into t_city(id,code,name,pcode)values(250,‘817‘,‘南充‘,‘0280‘);
insert into t_city(id,code,name,pcode)values(251,‘826‘,‘广安‘,‘0280‘);
insert into t_city(id,code,name,pcode)values(252,‘825‘,‘遂宁‘,‘0280‘);
insert into t_city(id,code,name,pcode)values(253,‘832‘,‘内江‘,‘0280‘);
insert into t_city(id,code,name,pcode)values(254,‘833‘,‘乐山‘,‘0280‘);
insert into t_city(id,code,name,pcode)values(255,‘813‘,‘自贡‘,‘0280‘);
insert into t_city(id,code,name,pcode)values(256,‘830‘,‘泸州‘,‘0280‘);
insert into t_city(id,code,name,pcode)values(257,‘831‘,‘宜宾‘,‘0280‘);
insert into t_city(id,code,name,pcode)values(258,‘812‘,‘攀枝花‘,‘0280‘);
insert into t_city(id,code,name,pcode)values(259,‘827‘,‘巴中‘,‘0280‘);
insert into t_city(id,code,name,pcode)values(260,‘818‘,‘达川‘,‘0280‘);
insert into t_city(id,code,name,pcode)values(261,‘835‘,‘雅安‘,‘0280‘);
insert into t_city(id,code,name,pcode)values(262,‘836‘,‘康定‘,‘0280‘);
insert into t_city(id,code,name,pcode)values(263,‘848‘,‘马尔康‘,‘0280‘);
insert into t_city(id,code,name,pcode)values(264,‘834‘,‘西昌‘,‘0280‘);
insert into t_city(id,code,name,pcode)values(265,‘851‘,‘贵阳‘,‘0851‘);
insert into t_city(id,code,name,pcode)values(266,‘858‘,‘六盘水‘,‘0851‘);
insert into t_city(id,code,name,pcode)values(267,‘852‘,‘遵义‘,‘0851‘);
insert into t_city(id,code,name,pcode)values(268,‘857‘,‘毕节‘,‘0851‘);
insert into t_city(id,code,name,pcode)values(269,‘856‘,‘铜仁‘,‘0851‘);
insert into t_city(id,code,name,pcode)values(270,‘853‘,‘安顺‘,‘0851‘);
insert into t_city(id,code,name,pcode)values(271,‘855‘,‘凯里‘,‘0851‘);
insert into t_city(id,code,name,pcode)values(272,‘854‘,‘都匀‘,‘0851‘);
insert into t_city(id,code,name,pcode)values(273,‘859‘,‘兴义‘,‘0851‘);
insert into t_city(id,code,name,pcode)values(274,‘871‘,‘昆明‘,‘0871‘);
insert into t_city(id,code,name,pcode)values(275,‘874‘,‘曲靖‘,‘0871‘);
insert into t_city(id,code,name,pcode)values(276,‘877‘,‘玉溪‘,‘0871‘);
insert into t_city(id,code,name,pcode)values(277,‘888‘,‘丽江‘,‘0871‘);
insert into t_city(id,code,name,pcode)values(278,‘870‘,‘昭通‘,‘0871‘);
insert into t_city(id,code,name,pcode)values(279,‘879‘,‘思茅‘,‘0871‘);
insert into t_city(id,code,name,pcode)values(280,‘883‘,‘临沧‘,‘0871‘);
insert into t_city(id,code,name,pcode)values(281,‘875‘,‘保山‘,‘0871‘);
insert into t_city(id,code,name,pcode)values(282,‘692‘,‘潞西‘,‘0871‘);
insert into t_city(id,code,name,pcode)values(283,‘886‘,‘泸水‘,‘0871‘);
insert into t_city(id,code,name,pcode)values(284,‘887‘,‘中甸‘,‘0871‘);
insert into t_city(id,code,name,pcode)values(285,‘872‘,‘大理‘,‘0871‘);
insert into t_city(id,code,name,pcode)values(286,‘878‘,‘楚雄‘,‘0871‘);
insert into t_city(id,code,name,pcode)values(287,‘873‘,‘个旧‘,‘0871‘);
insert into t_city(id,code,name,pcode)values(288,‘876‘,‘文山‘,‘0871‘);
insert into t_city(id,code,name,pcode)values(289,‘691‘,‘景洪‘,‘0871‘);
insert into t_city(id,code,name,pcode)values(290,‘891‘,‘拉萨‘,‘0891‘);
insert into t_city(id,code,name,pcode)values(291,‘896‘,‘那曲‘,‘0891‘);
insert into t_city(id,code,name,pcode)values(292,‘895‘,‘昌都‘,‘0891‘);
insert into t_city(id,code,name,pcode)values(293,‘894‘,‘林芝‘,‘0891‘);
insert into t_city(id,code,name,pcode)values(294,‘893‘,‘乃东‘,‘0891‘);
insert into t_city(id,code,name,pcode)values(295,‘892‘,‘日喀则‘,‘0891‘);
insert into t_city(id,code,name,pcode)values(296,‘897‘,‘噶尔‘,‘0891‘);
insert into t_city(id,code,name,pcode)values(297,‘290‘,‘西安‘,‘0290‘);
insert into t_city(id,code,name,pcode)values(298,‘911‘,‘延安‘,‘0290‘);
insert into t_city(id,code,name,pcode)values(299,‘919‘,‘铜川‘,‘0290‘);
insert into t_city(id,code,name,pcode)values(300,‘913‘,‘渭南‘,‘0290‘);
insert into t_city(id,code,name,pcode)values(301,‘910‘,‘咸阳‘,‘0290‘);
insert into t_city(id,code,name,pcode)values(302,‘917‘,‘宝鸡‘,‘0290‘);
insert into t_city(id,code,name,pcode)values(303,‘916‘,‘汉中‘,‘0290‘);
insert into t_city(id,code,name,pcode)values(304,‘912‘,‘榆林‘,‘0290‘);
insert into t_city(id,code,name,pcode)values(305,‘914‘,‘商州‘,‘0290‘);
insert into t_city(id,code,name,pcode)values(306,‘915‘,‘安康‘,‘0290‘);
insert into t_city(id,code,name,pcode)values(307,‘931‘,‘兰州‘,‘0931‘);
insert into t_city(id,code,name,pcode)values(308,‘943‘,‘白银‘,‘0931‘);
insert into t_city(id,code,name,pcode)values(309,‘938‘,‘天水‘,‘0931‘);
insert into t_city(id,code,name,pcode)values(310,‘937‘,‘酒泉‘,‘0931‘);
insert into t_city(id,code,name,pcode)values(311,‘936‘,‘张掖‘,‘0931‘);
insert into t_city(id,code,name,pcode)values(312,‘935‘,‘武威‘,‘0931‘);
insert into t_city(id,code,name,pcode)values(313,‘934‘,‘西峰‘,‘0931‘);
insert into t_city(id,code,name,pcode)values(314,‘933‘,‘平凉‘,‘0931‘);
insert into t_city(id,code,name,pcode)values(315,‘932‘,‘定西‘,‘0931‘);
insert into t_city(id,code,name,pcode)values(316,‘939‘,‘陇南‘,‘0931‘);
insert into t_city(id,code,name,pcode)values(317,‘930‘,‘临夏‘,‘0931‘);
insert into t_city(id,code,name,pcode)values(318,‘941‘,‘合作‘,‘0931‘);
insert into t_city(id,code,name,pcode)values(319,‘731‘,‘长沙‘,‘0731‘);
insert into t_city(id,code,name,pcode)values(320,‘744‘,‘张家界‘,‘0731‘);
insert into t_city(id,code,name,pcode)values(321,‘736‘,‘常德‘,‘0731‘);
insert into t_city(id,code,name,pcode)values(322,‘737‘,‘益阳‘,‘0731‘);
insert into t_city(id,code,name,pcode)values(323,‘730‘,‘岳阳‘,‘0731‘);
insert into t_city(id,code,name,pcode)values(324,‘733‘,‘株洲‘,‘0731‘);
insert into t_city(id,code,name,pcode)values(325,‘732‘,‘湘潭‘,‘0731‘);
insert into t_city(id,code,name,pcode)values(326,‘734‘,‘衡阳‘,‘0731‘);
insert into t_city(id,code,name,pcode)values(327,‘735‘,‘郴州‘,‘0731‘);
insert into t_city(id,code,name,pcode)values(328,‘746‘,‘永州‘,‘0731‘);
insert into t_city(id,code,name,pcode)values(329,‘739‘,‘邵阳‘,‘0731‘);
insert into t_city(id,code,name,pcode)values(330,‘745‘,‘怀化‘,‘0731‘);
insert into t_city(id,code,name,pcode)values(331,‘738‘,‘娄底‘,‘0731‘);
insert into t_city(id,code,name,pcode)values(332,‘743‘,‘吉首‘,‘0731‘);
insert into t_city(id,code,name,pcode)values(333,‘971‘,‘西宁‘,‘0971‘);
insert into t_city(id,code,name,pcode)values(334,‘972‘,‘平安‘,‘0971‘);
insert into t_city(id,code,name,pcode)values(335,‘970‘,‘海晏‘,‘0971‘);
insert into t_city(id,code,name,pcode)values(336,‘974‘,‘共和‘,‘0971‘);
insert into t_city(id,code,name,pcode)values(337,‘973‘,‘同仁‘,‘0971‘);
insert into t_city(id,code,name,pcode)values(338,‘975‘,‘玛沁‘,‘0971‘);
insert into t_city(id,code,name,pcode)values(339,‘976‘,‘玉树‘,‘0971‘);
insert into t_city(id,code,name,pcode)values(340,‘977‘,‘德令哈‘,‘0971‘);
insert into t_city(id,code,name,pcode)values(341,‘951‘,‘银川‘,‘0951‘);
insert into t_city(id,code,name,pcode)values(342,‘952‘,‘大武口‘,‘0951‘);
insert into t_city(id,code,name,pcode)values(343,‘953‘,‘吴忠‘,‘0951‘);
insert into t_city(id,code,name,pcode)values(344,‘954‘,‘固原‘,‘0951‘);
insert into t_city(id,code,name,pcode)values(345,‘991‘,‘乌鲁木齐‘,‘0991‘);
insert into t_city(id,code,name,pcode)values(346,‘990‘,‘克拉玛依‘,‘0991‘);
insert into t_city(id,code,name,pcode)values(347,‘993‘,‘石河子‘,‘0991‘);
insert into t_city(id,code,name,pcode)values(348,‘998‘,‘喀什‘,‘0991‘);
insert into t_city(id,code,name,pcode)values(349,‘997‘,‘阿克苏‘,‘0991‘);
insert into t_city(id,code,name,pcode)values(350,‘930‘,‘和田‘,‘0991‘);
insert into t_city(id,code,name,pcode)values(351,‘995‘,‘吐鲁番‘,‘0991‘);
insert into t_city(id,code,name,pcode)values(352,‘920‘,‘哈密‘,‘0991‘);
insert into t_city(id,code,name,pcode)values(353,‘980‘,‘阿图什‘,‘0991‘);
insert into t_city(id,code,name,pcode)values(354,‘990‘,‘博乐‘,‘0991‘);
insert into t_city(id,code,name,pcode)values(355,‘994‘,‘昌吉‘,‘0991‘);
insert into t_city(id,code,name,pcode)values(356,‘996‘,‘库尔勒‘,‘0991‘);
insert into t_city(id,code,name,pcode)values(357,‘999‘,‘伊宁‘,‘0991‘);
insert into t_city(id,code,name,pcode)values(358,‘992‘,‘奎屯‘,‘0991‘);
insert into t_city(id,code,name,pcode)values(359,‘910‘,‘塔城‘,‘0991‘);
insert into t_city(id,code,name,pcode)values(360,‘960‘,‘阿勒泰‘,‘0991‘);

区号数据库