全国城市mysql数据库（含拼音）

/* author: qinziheng website: http://www.qinziheng.com email: mobil: Date: 2015-08-05 11:37:10 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `zi_city` -- ---------------------------- DROP TABLE IF EXISTS `zi_city`; CREATE TABLE `zi_city` ( `CityID` bigint(20) NOT NULL, `CityName` varchar(50) DEFAULT NULL, `cid` int(8) DEFAULT '0', `pinyin` varchar(60) NOT NULL DEFAULT '', `status` tinyint(1) NOT NULL DEFAULT '0', `ZipCode` varchar(50) DEFAULT NULL, `ProvinceID` bigint(20) DEFAULT NULL, PRIMARY KEY (`CityID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of zi_city -- ---------------------------- INSERT INTO `zi_city` VALUES ('1', '北京市', '60', 'beijingshi', '1', '100000', '1'); INSERT INTO `zi_city` VALUES ('2', '天津市', '61', 'tianjinshi', '1', '100000', '2'); INSERT INTO `zi_city` VALUES ('3', '石家庄市', '62', 'shijiazhuangshi', '1', '050000', '3'); INSERT INTO `zi_city` VALUES ('4', '唐山市', '63', 'tangshanshi', '1', '063000', '3'); INSERT INTO `zi_city` VALUES ('5', '秦皇岛市', '64', 'qinhuangdaoshi', '1', '066000', '3'); INSERT INTO `zi_city` VALUES ('6', '邯郸市', '396', 'handanshi', '1', '056000', '3'); INSERT INTO `zi_city` VALUES ('7', '邢台市', '65', 'xingtaishi', '1', '054000', '3'); INSERT INTO `zi_city` VALUES ('8', '保定市', '66', 'baodingshi', '1', '071000', '3'); INSERT INTO `zi_city` VALUES ('9', '张家口市', '67', 'zhangjiakoushi', '1', '075000', '3'); INSERT INTO `zi_city` VALUES ('10', '承德市', '68', 'chengdeshi', '1', '067000', '3'); INSERT INTO `zi_city` VALUES ('11', '沧州市', '69', 'cangzhoushi', '1', '061000', '3'); INSERT INTO `zi_city` VALUES ('12', '廊坊市', '70', 'langfangshi', '1', '065000', '3'); INSERT INTO `zi_city` VALUES ('13', '衡水市', '71', 'hengshuishi', '1', '053000', '3'); INSERT INTO `zi_city` VALUES ('14', '太原市', '72', 'taiyuanshi', '1', '030000', '4'); INSERT INTO `zi_city` VALUES ('15', '大同市', '73', 'datongshi', '1', '037000', '4'); INSERT INTO `zi_city` VALUES ('16', '阳泉市', '74', 'yangquanshi', '1', '045000', '4'); INSERT INTO `zi_city` VALUES ('17', '长治市', '75', 'changzhishi', '1', '046000', '4'); INSERT INTO `zi_city` VALUES ('18', '晋城市', '76', 'jinchengshi', '1', '048000', '4'); INSERT INTO `zi_city` VALUES ('19', '朔州市', '77', 'shuozhoushi', '1', '036000', '4'); INSERT INTO `zi_city` VALUES ('20', '晋中市', '78', 'jinzhongshi', '1', '030600', '4'); INSERT INTO `zi_city` VALUES ('21', '运城市', '79', 'yunchengshi', '1', '044000', '4'); INSERT INTO `zi_city` VALUES ('22', '忻州市', '80', 'xinzhoushi', '1', '034000', '4'); INSERT INTO `zi_city` VALUES ('23', '临汾市', '81', 'linfenshi', '1', '041000', '4'); INSERT INTO `zi_city` VALUES ('24', '吕梁市', '82', 'lvliangshi', '1', '030500', '4'); INSERT INTO `zi_city` VALUES ('25', '呼和浩特市', '83', 'huhehaoteshi', '1', '010000', '5'); INSERT INTO `zi_city` VALUES ('26', '包头市', '84', 'baotoushi', '1', '014000', '5'); INSERT INTO `zi_city` VALUES ('27', '乌海市', '85', 'wuhaishi', '1', '016000', '5'); INSERT INTO `zi_city` VALUES ('28', '赤峰市', '86', 'chifengshi', '1', '024000', '5'); INSERT INTO `zi_city` VALUES ('29', '通辽市', '87', 'tongliaoshi', '1', '028000', '5'); INSERT INTO `zi_city` VALUES ('30', '鄂尔多斯市', '88', 'eerduosishi', '1', '010300', '5'); INSERT INTO `zi_city` VALUES ('31', '呼伦贝尔市', '89', 'hulunbeiershi', '1', '021000', '5'); INSERT INTO `zi_city` VALUES ('32', '巴彦淖尔市', '90', 'bayannaoershi', '1', '014400', '5'); INSERT INTO `zi_city` VALUES ('33', '乌兰察布市', '91', 'wulanchabushi', '1', '011800', '5'); INSERT INTO `zi_city` VALUES ('34', '兴安盟', '92', 'xinganmeng', '1', '137500', '5'); INSERT INTO `zi_city` VALUES ('35', '锡林郭勒盟', '93', 'xilinguolemeng', '1', '011100', '5'); INSERT INTO `zi_city` VALUES ('36', '阿拉善盟', '94', 'alashanmeng', '1', '016000', '5'); INSERT INTO `zi_city` VALUES ('37', '沈阳市', '95', 'shenyangshi', '1', '110000', '6'); INSERT INTO `zi_city` VALUES ('38', '大连市', '96', 'dalianshi', '1', '116000', '6'); INSERT INTO `zi_city` VALUES ('39', '鞍山市', '97', 'anshanshi', '1', '114000', '6'); INSERT INTO `zi_city` VALUES ('40', '抚顺市', '98', 'fushunshi', '1', '113000', '6'); INSERT INTO `zi_city` VALUES ('41', '本溪市', '99', 'benxishi', '1', '117000', '6'); INSERT INTO `zi_city` VALUES ('42', '丹东市', '100', 'dandongshi', '1', '118000', '6'); INSERT INTO `zi_city` VALUES ('43', '锦州市', '101', 'jinzhoushi', '1', '121000', '6'); INSERT INTO `zi_city` VALUES ('44', '营口市', '102', 'yingkoushi', '1', '115000', '6'); INSERT INTO `zi_city` VALUES ('45', '阜新市', '103', 'fuxinshi', '1', '123000', '6'); INSERT INTO `zi_city` VALUES ('46', '辽阳市', '104', 'liaoyangshi', '1', '111000', '6'); INSERT INTO `zi_city` VALUES ('47', '盘锦市', '105', 'panjinshi', '1', '124000', '6'); INSERT INTO `zi_city` VALUES ('48', '铁岭市', '106', 'tielingshi', '1', '112000', '6'); INSERT INTO `zi_city` VALUES ('49', '朝阳市', '107', 'chaoyangshi', '1', '122000', '6'); INSERT INTO `zi_city` VALUES ('50', '葫芦岛市', '108', 'huludaoshi', '1', '125000', '6'); INSERT INTO `zi_city` VALUES ('51', '长春市', '109', 'changchunshi', '1', '130000', '7'); INSERT INTO `zi_city` VALUES ('52', '吉林市', '110', 'jilinshi', '1', '132000', '7'); INSERT INTO `zi_city` VALUES ('53', '四平市', '111', 'sipingshi', '1', '136000', '7'); INSERT INTO `zi_city` VALUES ('54', '辽源市', '112', 'liaoyuanshi', '0', '136200', '7'); INSERT INTO `zi_city` VALUES ('55', '通化市', '113', 'tonghuashi', '1', '134000', '7'); INSERT INTO `zi_city` VALUES ('56', '白山市', '114', 'baishanshi', '1', '134300', '7'); INSERT INTO `zi_city` VALUES ('57', '松原市', '115', 'songyuanshi', '1', '131100', '7'); INSERT INTO `zi_city` VALUES ('58', '白城市', '116', 'baichengshi', '1', '137000', '7'); INSERT INTO `zi_city` VALUES ('59', '延边朝鲜族自治州', '117', 'yanbianchaoxianzuzizhizhou', '1', '133000', '7'); INSERT INTO `zi_city` VALUES ('60', '哈尔滨市', '118', 'haerbinshi', '1', '150000', '8'); INSERT INTO `zi_city` VALUES ('61', '齐齐哈尔市', '119', 'qiqihaershi', '1', '161000', '8'); INSERT INTO `zi_city` VALUES ('62', '鸡西市', '120', 'jixishi', '1', '158100', '8'); INSERT INTO `zi_city` VALUES ('63', '鹤岗市', '121', 'hegangshi', '1', '154100', '8'); INSERT INTO `zi_city` VALUES ('64', '双鸭山市', '122', 'shuangyashanshi', '1', '155100', '8'); INSERT INTO `zi_city` VALUES ('65', '大庆市', '123', 'daqingshi', '1', '163000', '8'); INSERT INTO `zi_city` VALUES ('66', '伊春市', '124', 'yichunshi', '1', '152300', '8'); INSERT INTO `zi_city` VALUES ('67', '佳木斯市', '125', 'jiamusishi', '1', '154000', '8'); INSERT INTO `zi_city` VALUES ('68', '七台河市', '126', 'qitaiheshi', '1', '154600', '8'); INSERT INTO `zi_city` VALUES ('69', '牡丹江市', '127', 'mudanjiangshi', '1', '157000', '8'); INSERT INTO `zi_city` VALUES ('70', '黑河市', '128', 'heiheshi', '1', '164300', '8'); INSERT INTO `zi_city` VALUES ('71', '绥化市', '129', 'suihuashi', '1', '152000', '8'); INSERT INTO `zi_city` VALUES ('72', '大兴安岭地区', '130', 'daxinganlingdiqu', '1', '165000', '8'); INSERT INTO `zi_city` VALUES ('73', '上海市', '131', 'shanghaishi', '1', '200000', '9'); INSERT INTO `zi_city` VALUES ('74', '南京市', '132', 'nanjingshi', '1', '210000', '10'); INSERT INTO `zi_city` VALUES ('75', '无锡市', '133', 'wuxishi', '1', '214000', '10'); INSERT INTO `zi_city` VALUES ('76', '徐州市', '134', 'xuzhoushi', '1', '221000', '10'); INSERT INTO `zi_city` VALUES ('77', '常州市', '135', 'changzhoushi', '1', '213000', '10'); INSERT INTO `zi_city` VALUES ('78', '苏州市', '136', 'suzhoushi', '1', '21