mysql 中国城市区号

DROP TABLE IF EXISTS `city`; CREATE TABLE `city` ( `Id` int(11) NOT NULL auto_increment, `province` varchar(255) default NULL, `city` varchar(255) default NULL, `number` varchar(4) character set utf8 default NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=368 DEFAULT CHARSET=gbk; -- ---------------------------- - - Records of city -- ---------------------------- INSERT INTO `city` VALUES ('1', '北京', '北京', '010'); INSERT INTO `city` VALUES ('2', '天津', '天津', '022'); INSERT INTO `city` VALUES ('3', '河北', '石家庄', '0311'); INSERT INTO `city` VALUES ('4', '河北', '保定', '0312'); INSERT INTO `city` VALUES ('5', '河北', '张家口', '0313'); INSERT INTO `city` VALUES ('6', '河北', '承德', '0314'); - Records of city -- ---------------------------- INSERT INTO `city` VALUES ('1', '北京', '北京', '010'); INSERT INTO `city` VALUES ('2', '天津', '天津', '022'); INSERT INTO `city` VALUES ('3', '河北', '石家庄', '0311'); INSERT INTO `city` VALUES ('4', '河北', '保定', '0312'); INSERT INTO `city` VALUES ('5', '河北', '张家口', '0313'); INSERT INTO `city` VALUES ('6', '河北', '承德', '0314');