中国邮政编码 mysql 语句

DROP TABLE IF EXISTS `areas`; CREATE TABLE `areas` ( `id` int(11) NOT NULL auto_increment, `areaid` varchar(20) NOT NULL, `area` varchar(50) NOT NULL, `cityid` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; insert into areas(id,areaid,area,cityid) values(1,'110101','东城区','110100'); insert into areas(id,areaid,area,cityid) values(2,'110102','西城区','110100'); insert into areas(id,areaid,area,cityid) values(3,'110103','崇文区','110100'); insert into areas(id,areaid,area,cityid) values(4,'110104','宣武区','110100'); insert into areas(id,areaid,area,cityid) values(5,'110105','朝阳区','110100'); insert into areas(id,areaid,area,cityid) values(6,'110106','丰台区','110100'); insert into areas(id,areaid,area,cityid) values(7,'110107','石景山区','110100'); insert into areas(id,areaid,area,cityid) values(8,'110108','海淀区','110100'); insert into areas(id,areaid,area,cityid) values(9,'110109','门头沟区','110100'); insert into areas(id,areaid,area,cityid) values(10,'110111','房山区','110100'); insert into areas(id,areaid,area,cityid) values(11,'110112','通州区','110100'); insert into areas(id,areaid,area,cityid) values(12,'110113','顺义区','110100'); insert into areas(id,areaid,area,cityid) values(13,'110114','昌平区','110100'); insert into areas(id,areaid,area,cityid) values(14,'110115','大兴区','110100'); insert into areas(id,areaid,area,cityid) values(15,'110116','怀柔区','110100'); insert into areas(id,areaid,area,cityid) values(16,'110117','平谷区','110100'); insert into areas(id,areaid,area,cityid) values(17,'110228','密云县','110200'); insert into areas(id,areaid,area,cityid) values(18,'110229','延庆县','110200'); insert into areas(id,areaid,area,cityid) values(19,'120101','和平区','120100'); insert into areas(id,areaid,area,cityid) values(20,'120102','河东区','120100'); insert into areas(id,areaid,area,cityid) values(21,'120103','河西区','120100'); insert into areas(id,areaid,area,cityid) values(22,'120104','南开区','120100'); insert into areas(id,areaid,area,cityid) values(23,'120105','河北区','120100'); insert into areas(id,areaid,area,cityid) values(24,'120106','红桥区','120100'); insert into areas(id,areaid,area,cityid) values(25,'120107','塘沽区','120100'); insert into areas(id,areaid,area,cityid) values(26,'120108','汉沽区','120100'); insert into areas(id,areaid,area,cityid) values(27,'120109','大港区','120100'); insert into areas(id,areaid,area,cityid) values(28,'120110','东丽区','120100'); insert into areas(id,areaid,area,cityid) values(29,'120111','西青区','120100'); insert into areas(id,areaid,area,cityid) values(30,'120112','津南区','120100'); insert into areas(id,areaid,area,cityid) values(31,'120113','北辰区','120100'); insert into areas(id,areaid,area,cityid) values(32,'120114','武清区','120100'); insert into areas(id,areaid,area,cityid) values(33,'120115','宝坻区','120100'); insert into areas(id,areaid,area,cityid) values(34,'120221','宁河县','120200'); insert into areas(id,areaid,area,cityid) values(35,'120223','静海县','120200'); insert into areas(id,areaid,area,cityid) values(36,'120225','蓟　县','120200'); insert into areas(id,areaid,area,cityid) values(37,'130101','市辖区','130100'); insert into areas(id,areaid,area,cityid) values(38,'130102','长安区','130100'); insert into areas(id,areaid,area,cityid) values(39,'130103','桥东区','130100'); insert into areas(id,areaid,area,cityid) values(40,'130104','桥西区','130100'); insert into areas(id,areaid,area,cityid) values(41,'130105','新华区','130100'); insert into areas(id,areaid,area,cityid) values(42,'130107','井陉矿区','130100'); insert into areas(id,areaid,area,cityid) values(43,'130108','裕华区','130100'); insert into areas(id,areaid,area,cityid) values(44,'130121','井陉县','130100'); insert into areas(id,areaid,area,cityid) values(45,'130123','正定县','130100'); insert into areas(id,areaid,area,cityid) values(46,'130124','栾城县','130100'); insert into areas(id,areaid,area,cityid) values(47,'130125','行唐县','130100'); insert into areas(id,areaid,area,cityid) values(48,'130126','灵寿县','130100'); insert into areas(id,areaid,area,cityid) values(49,'130127','高邑县','130100'); insert into areas(id,areaid,area,cityid) values(50,'130128','深泽县','130100'); insert into areas(id,areaid,area,cityid) values(51,'130129','赞皇县','130100'); insert into areas(id,areaid,area,cityid) values(52,'130130','无极县','130100'); insert into areas(id,areaid,area,cityid) values(53,'130131','平山县','130100'); insert into areas(id,areaid,area,cityid) values(54,'130132','元氏县','130100'); insert into areas(id,areaid,area,cityid) values(55,'130133','赵　县','130100'); insert into areas(id,areaid,area,cityid) values(56,'130181','辛集市','130100'); insert into areas(id,areaid,area,cityid) values(57,'130182','藁城市','130100'); insert into areas(id,areaid,area,cityid) values(58,'130183','晋州市','130100'); insert into areas(id,areaid,area,cityid) values(59,'130184','新乐市','130100'); insert into areas(id,areaid,area,cityid) values(60,'130185','鹿泉市','130100'); insert into areas(id,areaid,area,cityid) values(61,'130201','市辖区','130200'); insert into areas(id,areaid,area,cityid) values(62,'130202','路南区','130200'); insert into areas(id,areaid,area,cityid) values(63,'130203','路北区','130200'); insert into areas(id,areaid,area,cityid) values(64,'130204','古冶区','130200'); insert into areas(id,areaid,area,cityid) values(65,'130205','开平区','130200'); insert into areas(id,areaid,area,cityid) values(66,'130207','丰南区','130200'); insert into areas(id,areaid,area,cityid) values(67,'130208','丰润区','130200'); insert into areas(id,areaid,area,cityid) values(68,'130223','滦　县','130200'); insert into areas(id,areaid,area,cityid) values(69,'130224','滦南县','130200'); insert into areas(id,areaid,area,cityid) values(70,'130225','乐亭县','130200'); insert into areas(id,areaid,area,cityid) values(71,'130227','迁西县','130200'); insert into areas(id,areaid,area,cityid) values(72,'130229','玉田县','130200'); insert into areas(id,areaid,area,cityid) values(73,'130230','唐海县','130200'); insert into areas(id,areaid,area,cityid) values(74,'130281','遵化市','130200'); insert into areas(id,areaid,area,cityid) values(75,'130283','迁安市','130200'); insert into areas(id,areaid,area,cityid) values(76,'130301','市辖区','130300'); insert into areas(id,areaid,area,cityid) values(77,'130302','海港区','130300'); insert into areas(id,areaid,area,cityid) values(78,'130303','山海关区','130300'); insert into areas(id,areaid,area,cityid) values(79,'130304','北戴河区','130300'); insert into areas(id,areaid,area,cityid) values(80,'130321','青龙满族自治县','130300'); insert into areas(id,areaid,area,cityid) values(81,'130322','昌黎县','130300'); insert into areas(id,areaid,area,cityid) values(82,'130323','抚宁县','130300'); insert into areas(id,areaid,area,cityid) values(83,'130324','卢龙县','130300'); insert into areas(id,areaid,area,cityid) values(84,'130401','市辖区','130400'); insert into areas(id,areaid,area,cityid) values(85,'130402','邯山区','130400'); insert into areas(id,areaid,area,cityid) values(86,'130403','丛台区','130400'); insert into areas(id,areaid,area,cityid) values(87,'130404','复兴区','130400'); insert into areas(id,areaid,area,cityid) values(88,'130406','峰峰矿区','130400'); insert into areas(id,areaid,area,cityid) values(89,'130421','邯郸县','130400'); insert into areas(id,areaid,area,cityid) values(90,'130423','临漳县','130400'); insert into areas(id,areaid,area,cityid) values(91,'130424','成安县','130400'); insert into areas(id,areaid,area,cityid) values(92,'130425','大名县','130400'); insert into areas(id,areaid,area,cityid) values(93,'130426','涉　县','130400'); insert into areas(id,areaid,area,cityid) values(94,'130427','磁　县','130400'); insert into areas(id,areaid,area,cityid) values(95,'130428','肥乡县','130400'); insert into areas(id,areaid,area