省市邮编区号数据库+mysql.sql

-- phpMyAdmin SQL Dump -- version 3.1.3 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2009 年 05 月 15 日 02:27 -- 服务器版本: 5.1.30 -- PHP 版本: 5.2.8 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- 数据库: `static_page` -- -- -------------------------------------------------------- -- -- 表的结构 `city` -- CREATE TABLE IF NOT EXISTS `city` ( `c_id` int(11) NOT NULL COMMENT 'id', `c_name` varchar(20) COLLATE utf8_unicode_ci NOT NULL COMMENT '城市名', `c_zcode` char(6) COLLATE utf8_unicode_ci NOT NULL COMMENT '邮编', `c_pcode` varchar(6) COLLATE utf8_unicode_ci NOT NULL COMMENT '电话区号', `p_id` int(11) NOT NULL COMMENT '省id', PRIMARY KEY (`c_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- 导出表中的数据 `city` -- INSERT INTO `city` (`c_id`, `c_name`, `c_zcode`, `c_pcode`, `p_id`) VALUES (1, '北京市', '100000', '010', 1), (2, '天津市', '300000', '022', 2), (3, '石家庄市', '050000', '0311', 3), (4, '唐山市', '063000', '0315', 3), (5, '秦皇岛市', '066000', '0335', 3), (6, '邯郸市', '056000', '0310', 3), (7, '邢台市', '054000', '0319', 3), (8, '保定市', '071000', '0312', 3), (9, '张家口市', '075000', '0313', 3), (10, '承德市', '067000', '0314', 3), (11, '沧州市', '061000', '0317', 3), (12, '廊坊市', '065000', '0316', 3), (13, '衡水市', '053000', '0318', 3), (14, '太原市', '030000', '0351', 4), (15, '大同市', '037000', '0352', 4), (16, '阳泉市', '045000', '0353', 4), (17, '长治市', '046000', '0355', 4), (18, '晋城市', '048000', '0356', 4), (19, '朔州市', '036000', '0349', 4), (20, '晋中市', '030600', '0354', 4), (21, '运城市', '044000', '0359', 4), (22, '忻州市', '034000', '0350', 4), (23, '临汾市', '041000', '0357', 4), (24, '吕梁市', '033000', '0358', 4), (25, '呼和浩特市', '010000', '0471', 5), (26, '包头市', '014000', '0472', 5), (28, '赤峰市', '024000', '0476', 5), (29, '通辽市', '028000', '0475', 5), (30, '鄂尔多斯市', '014300', '0477', 5), (31, '呼伦贝尔市', '010000', '0471', 5), (32, '巴彦淖尔市', '015000', '0478', 5), (33, '乌兰察布市', '011800', '0474', 5), (34, '兴安盟', '029400', '0482', 5), (35, '锡林郭勒盟', '026000', '0479', 5), (36, '阿拉善盟', '735400', '0483', 5), (37, '沈阳市', '110000', '024', 6), (38, '大连市', '116000', '0411', 6), (39, '鞍山市', '114000', '0412', 6), (40, '抚顺市', '113000', '0413', 6), (41, '本溪市', '117000', '0414', 6), (42, '丹东市', '118000', '0415', 6), (43, '锦州市', '121000', '0416', 6), (44, '营口市', '115000', '0417', 6), (45, '阜新市', '123000', '0418', 6), (46, '辽阳市', '111000', '0419', 6), (47, '盘锦市', '124000', '0427', 6), (48, '铁岭市', '112000', '0410', 6), (49, '朝阳市', '122000', '0421', 6), (50, '葫芦岛市', '125000', '0429', 6), (51, '长春市', '130000', '0431', 7), (52, '吉林市', '132000', '0432', 7), (53, '四平市', '136000', '0434', 7), (54, '辽源市', '136200', '0437', 7), (55, '通化市', '134000', '0435', 7), (56, '白山市', '134300', '0439', 7), (57, '松原市', '138000', '0438', 7), (58, '白城市', '137000', '0436', 7), (59, '延边朝鲜族自治州', '133000', '0433', 7), (60, '哈尔滨市', '150000', '0451', 8), (61, '齐齐哈尔市', '161000', '0452', 8), (62, '鸡西市', '158100', '0467', 8), (63, '鹤岗市', '154100', '0468', 8), (64, '双鸭山市', '155100', '0469', 8), (65, '大庆市', '163000', '0459', 8), (66, '伊春市', '153000', '0458', 8), (67, '佳木斯市', '154000', '0454', 8), (68, '七台河市', '154600', '0464', 8), (69, '牡丹江市', '157000', '0453', 8), (70, '黑河市', '164300', '0456', 8), (71, '绥化市', '152000', '0455', 8), (72, '大兴安岭地区', '165000', '0457', 8), (73, '上海市', '200000', '021', 9), (74, '南京市', '210000', '025', 10), (75, '无锡市', '214000', '0510', 10), (76, '徐州市', '221000', '0516', 10), (77, '常州市', '213000', '0519', 10), (78, '苏州市', '215000', '0512', 10), (79, '南通市', '226000', '0513', 10), (80, '连云港市', '222000', '0518', 10), (81, '淮安市', '223001', '0517', 10), (82, '盐城市', '224000', '0515', 10), (83, '扬州市', '225000', '0514', 10), (84, '镇江市', '212000', '0511', 10), (85, '泰州市', '225300', '0523', 10), (86, '宿迁市', '223800', '0527', 10), (87, '杭州市', '310000', '0571', 11), (88, '宁波市', '315000', '0574', 11), (89, '温州市', '325000', '0577', 11), (90, '嘉兴市', '314000', '0573', 11), (91, '湖州市', '313000', '0572', 11), (92, '绍兴市', '312000', '0575', 11), (93, '金华市', '321000', '0579', 11), (94, '衢州市', '324000', '0570', 11), (95, '舟山市', '316000', '0580', 11), (96, '台州市', '318000', '0576', 11), (97, '丽水市', '323000', '0578', 11), (98, '合肥市', '230000', '0551', 12), (99, '芜湖市', '241000', '0553', 12), (100, '蚌埠市', '233000', '0552', 12), (101, '淮南市', '232000', '0554', 12), (102, '马鞍山市', '243000', '0555', 12), (103, '淮北市', '235000', '0561', 12), (104, '铜陵市', '244000', '0562', 12), (105, '安庆市', '246000', '0556', 12), (106, '黄山市', '242700', '0559', 12), (107, '滁州市', '239000', '0550', 12), (108, '阜阳市', '236000', '0558', 12), (109, '宿州市', '234000', '0557', 12), (110, '巢湖市', '238000', '0565', 12), (111, '六安市', '237000', '0564', 12), (112, '亳州市', '236000', '0558', 12), (113, '池州市', '247100', '0566', 12), (114, '宣城市', '242000', '0563', 12), (115, '福州市', '350000', '0591', 13), (116, '厦门市', '361000', '0592', 13), (117, '莆田市', '351100', '0594', 13), (118, '三明市', '365000', '0598', 13), (119, '泉州市', '362000', '0595', 13), (120, '漳州市', '363000', '0596', 13), (121, '南平市', '353000', '0599', 13), (122, '龙岩市', '364000', '0597', 13), (123, '宁德市', '352000', '0593', 13), (124, '南昌市', '330000', '0791', 14), (125, '景德镇市', '333000', '0798', 14), (126, '萍乡市', '337000', '0799', 14), (127, '九江市', '332000', '0792', 14), (128, '新余市', '338000', '0790', 14), (129, '鹰潭市', '335000', '0701', 14), (130, '赣州市', '341000', '0797', 14), (131, '吉安市', '343000', '0796', 14), (132, '宜春市', '336000', '0795', 14), (133, '抚州市', '344000', '0794', 14), (134, '上饶市', '334000', '0793', 14), (135, '济南市', '250000', '0531', 15), (136, '青岛市', '266000', '0532', 15), (137, '淄博市', '255000', '0533', 15), (138, '枣庄市', '277000', '0632', 15), (139, '东营市', '257000', '0546', 15), (140, '烟台市', '264000', '0535', 15), (141, '潍坊市', '261000', '0536', 15), (142, '济宁市', '272000', '0537', 15), (143, '泰安市', '271000', '0538', 15), (144, '威海市', '264200', '0631', 15), (145, '日照市', '276800', '0633', 15), (146, '莱芜市', '271100', '0634', 15), (147, '临沂市', '276000', '0539', 15), (148, '德州市', '253000', '0534', 15), (149, '聊城市', '252000', '0635', 15), (150, '滨州市', '256600', '0543', 15), (151, '荷泽市', '274000', '0530', 15), (152, '郑州市', '450000', '0371', 16), (153, '开封市', '475000', '0378', 16), (154, '洛阳市', '471000', '0379', 16), (155, '平顶山市', '467000', '0375', 16), (156, '安阳市', '455000', '0372', 16), (157, '鹤壁市', '458000', '0392', 16), (158, '新乡市', '453000', '0373', 16), (159, '焦作市', '454150', '0391', 16), (160, '濮阳市', '457000', '0393', 16), (161, '许昌市', '461000', '0374', 16), (162, '漯河市', '462000', '0395', 16), (163, '三门峡市', '472000', '0398', 16), (164, '南阳市', '473000', '0377', 16), (165, '商丘市', '476000', '0370', 16), (166, '信阳市', '464000', '0376', 16), (167, '周口�