全国市区区号邮编【Mysql】[2012年1月上传]

-- phpMyAdmin SQL Dump -- version 2.10.2 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2012 年 01 月 10 日 03:35 -- 服务器版本: 5.0.45 -- PHP 版本: 5.2.3 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- 数据库: `city` -- -- -------------------------------------------------------- -- -- 表的结构 `think_postcode` -- CREATE TABLE `think_postcode` ( `id` int(6) NOT NULL auto_increment, `name` varchar(50) NOT NULL, `areacode` varchar(4) NOT NULL, `zipcode` varchar(6) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3290 ; -- -- 导出表中的数据 `think_postcode` -- INSERT INTO `think_postcode` VALUES (1, '北京', '010', '100000'); INSERT INTO `think_postcode` VALUES (2, '东城区', '010', '100000'); INSERT INTO `think_postcode` VALUES (3, '西城区', '010', '100000'); INSERT INTO `think_postcode` VALUES (4, '崇文区', '010', '100000'); INSERT INTO `think_postcode` VALUES (5, '宣武区', '010', '100000'); INSERT INTO `think_postcode` VALUES (6, '朝阳区', '010', '100000'); INSERT INTO `think_postcode` VALUES (7, '丰台区', '010', '100000'); INSERT INTO `think_postcode` VALUES (8, '石景山区', '010', '100000'); INSERT INTO `think_postcode` VALUES (9, '海淀区', '010', '100000'); INSERT INTO `think_postcode` VALUES (10, '通州区', '010', '101100'); INSERT INTO `think_postcode` VALUES (11, '通县', '010', '101100'); INSERT INTO `think_postcode` VALUES (12, '平谷区', '010', '101200'); INSERT INTO `think_postcode` VALUES (13, '平台', '010', '101200'); INSERT INTO `think_postcode` VALUES (14, '顺义区', '010', '101300'); INSERT INTO `think_postcode` VALUES (15, '怀柔区', '010', '101400'); INSERT INTO `think_postcode` VALUES (16, '密云县', '010', '101500'); INSERT INTO `think_postcode` VALUES (17, '延庆县', '010', '102100'); INSERT INTO `think_postcode` VALUES (18, '昌平区', '010', '102200'); INSERT INTO `think_postcode` VALUES (19, '门头沟区', '010', '102300'); INSERT INTO `think_postcode` VALUES (20, '房山区', '010', '102400'); INSERT INTO `think_postcode` VALUES (21, '大兴区', '010', '102600'); INSERT INTO `think_postcode` VALUES (22, '天津', '022', '300000'); INSERT INTO `think_postcode` VALUES (23, '和平区', '022', '300000'); INSERT INTO `think_postcode` VALUES (24, '河东区', '022', '300000'); INSERT INTO `think_postcode` VALUES (25, '河西区', '022', '300000'); INSERT INTO `think_postcode` VALUES (26, '南开区', '022', '300000'); INSERT INTO `think_postcode` VALUES (27, '河北区', '022', '300000'); INSERT INTO `think_postcode` VALUES (28, '红桥区', '022', '300000'); INSERT INTO `think_postcode` VALUES (29, '大港区', '022', '300000'); INSERT INTO `think_postcode` VALUES (30, '东丽区', '022', '300000'); INSERT INTO `think_postcode` VALUES (31, '西青区', '022', '300000'); INSERT INTO `think_postcode` VALUES (32, '津南区', '022', '300000'); INSERT INTO `think_postcode` VALUES (33, '北辰区', '022', '300000'); INSERT INTO `think_postcode` VALUES (34, '塘沽区', '022', '300450'); INSERT INTO `think_postcode` VALUES (35, '汉沽区', '022', '300480'); INSERT INTO `think_postcode` VALUES (36, '宁河县', '022', '301500'); INSERT INTO `think_postcode` VALUES (37, '静海县', '022', '301600'); INSERT INTO `think_postcode` VALUES (38, '武清区', '022', '301700'); INSERT INTO `think_postcode` VALUES (39, '宝坻区', '022', '301800'); INSERT INTO `think_postcode` VALUES (40, '蓟县', '022', '301900'); INSERT INTO `think_postcode` VALUES (41, '邯郸', '0310', '056000'); INSERT INTO `think_postcode` VALUES (42, '邯郸县', '0310', '056000'); INSERT INTO `think_postcode` VALUES (43, '邯山区', '0310', '056000'); INSERT INTO `think_postcode` VALUES (44, '丛台区', '0310', '056000'); INSERT INTO `think_postcode` VALUES (45, '复兴区', '0310', '056000'); INSERT INTO `think_postcode` VALUES (46, '峰峰矿区', '0310', '056200'); INSERT INTO `think_postcode` VALUES (47, '武安市', '0310', '056300'); INSERT INTO `think_postcode` VALUES (48, '涉县', '0310', '056400'); INSERT INTO `think_postcode` VALUES (49, '磁县', '0310', '056500'); INSERT INTO `think_postcode` VALUES (50, '临漳县', '0310', '056600'); INSERT INTO `think_postcode` VALUES (51, '成安县', '0310', '056700'); INSERT INTO `think_postcode` VALUES (52, '魏县', '0310', '056800'); INSERT INTO `think_postcode` VALUES (53, '大名县', '0310', '056900'); INSERT INTO `think_postcode` VALUES (54, '永年县', '0310', '057150'); INSERT INTO `think_postcode` VALUES (55, '曲周县', '0310', '057250'); INSERT INTO `think_postcode` VALUES (56, '鸡泽县', '0310', '057350'); INSERT INTO `think_postcode` VALUES (57, '邱县', '0310', '057450'); INSERT INTO `think_postcode` VALUES (58, '肥乡县', '0310', '057550'); INSERT INTO `think_postcode` VALUES (59, '广平县', '0310', '057650'); INSERT INTO `think_postcode` VALUES (60, '馆陶县', '0310', '057750'); INSERT INTO `think_postcode` VALUES (61, '丘县', '0310', '057400'); INSERT INTO `think_postcode` VALUES (62, '获鹿', '0311', '050200'); INSERT INTO `think_postcode` VALUES (63, '石家庄', '0311', '050000'); INSERT INTO `think_postcode` VALUES (64, '长安区', '0311', '050000'); INSERT INTO `think_postcode` VALUES (65, '桥东区', '0311', '050000'); INSERT INTO `think_postcode` VALUES (66, '桥西区', '0311', '050000'); INSERT INTO `think_postcode` VALUES (67, '新华区', '0311', '050000'); INSERT INTO `think_postcode` VALUES (68, '裕华区', '0311', '050000'); INSERT INTO `think_postcode` VALUES (69, '井陉矿区', '0311', '050100'); INSERT INTO `think_postcode` VALUES (70, '鹿泉市', '0311', '050200'); INSERT INTO `think_postcode` VALUES (71, '井陉县', '0311', '050300'); INSERT INTO `think_postcode` VALUES (72, '平山县', '0311', '050400'); INSERT INTO `think_postcode` VALUES (73, '灵寿县', '0311', '050500'); INSERT INTO `think_postcode` VALUES (74, '行唐县', '0311', '050600'); INSERT INTO `think_postcode` VALUES (75, '新乐市', '0311', '050700'); INSERT INTO `think_postcode` VALUES (76, '正定县', '0311', '050800'); INSERT INTO `think_postcode` VALUES (77, '元氏县', '0311', '051130'); INSERT INTO `think_postcode` VALUES (78, '赞皇县', '0311', '051230'); INSERT INTO `think_postcode` VALUES (79, '高邑县', '0311', '051330'); INSERT INTO `think_postcode` VALUES (80, '栾城县', '0311', '051430'); INSERT INTO `think_postcode` VALUES (81, '赵县', '0311', '051530'); INSERT INTO `think_postcode` VALUES (82, '藁城市', '0311', '052160'); INSERT INTO `think_postcode` VALUES (83, '晋州市', '0311', '052200'); INSERT INTO `think_postcode` VALUES (84, '辛集市', '0311', '052300'); INSERT INTO `think_postcode` VALUES (85, '无极县', '0311', '052400'); INSERT INTO `think_postcode` VALUES (86, '深泽县', '0311', '052500'); INSERT INTO `think_postcode` VALUES (87, '保定', '0312', '071000'); INSERT INTO `think_postcode` VALUES (88, '新市区', '0312', '071000'); INSERT INTO `think_postcode` VALUES (89, '北市区', '0312', '071000'); INSERT INTO `think_postcode` VALUES (90, '南市区', '0312', '071000'); INSERT INTO `think_postcode` VALUES (91, '清苑县', '0312', '071100'); INSERT INTO `think_postcode` VALUES (92, '安国市', '0312', '071200'); INSERT INTO `think_postcode` VALUES (93, '博野县', '0312', '071300'); INSERT INTO `think_postcode` VALUES (94, '蠡县', '0312', '071400'); INSERT INTO `think_postcode` VALUES (95, '高阳县', '0312', '071500'); INSERT INTO `think_postcode` VALUES (96, '安新县', '0312', '071600'); INSERT INTO `think_postcode` VALUES (97, '容城县', '0312', '071700'); INSERT INTO `think_postcode` VALUES (98, '雄县', '0312', '071800'); INSERT INTO `think_postcode` VALUES (99, '满城县', '0312', '072150'); INSERT INTO `think_postcode` VALUES (100, '顺平县', '0312', '072250'); INSERT INTO `think_postcode` VALUES (101, '唐县', '0312', '072350'); INSERT INTO `think_postcode` VALUES (102, '望都