全世界127个主要国家Mysql数据库下载 10 February 2011 14:29 Thursday by 小屋 浏览(1567)

项目需要。。找了下,改了下,藏。


SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `country`
-- ----------------------------
DROP TABLE IF EXISTS `country`;
CREATE TABLE `country` (
  `country_id` tinyint(3) NOT NULL auto_increment,
  `code` varchar(16) NOT NULL,
  `name_chinese` varchar(128) NOT NULL,
  `name_english` varchar(128) NOT NULL,
  PRIMARY KEY  (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8;


-- ----------------------------
-- Records of country
-- ----------------------------
INSERT INTO `country` VALUES ('1', '00', '未知的國家', 'Unknown Country');
INSERT INTO `country` VALUES ('2', 'TT', '千里達與托貝哥共和國 (Trinidad and Tobago)', 'Trinidad and Tobago');
INSERT INTO `country` VALUES ('3', 'TV', '土瓦魯 (Tuvalu)', 'Tuvalu');
INSERT INTO `country` VALUES ('4', 'TR', '土耳其 (Türkiye)', 'T

阅读全文>>