注:其中省份城市目前只有中国的。
DROP TABLE IF EXISTS `nation`;
CREATE TABLE `nation` (
`n_ID` int(10) NOT NULL,
`n_name` varchar(30) NOT NULL,
PRIMARY KEY (`n_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO nation VALUES ('1', '中国');
INSERT INTO nation VALUES ('2', '阿尔巴尼亚');
INSERT INTO nation VALUES ('3', '阿尔及利亚');
INSERT INTO nation VALUES ('4', '阿富汗');
INSERT INTO nation VALUES ('5', '阿根廷');
INSERT INTO nation VALUES ('6', '阿拉伯联合酋长国');
INSERT INTO nation VALUES ('7', '阿鲁巴');
INSERT INTO nation VALUES ('8', '阿曼');
INSERT INTO nation VALUES ('9', '阿塞拜疆');
INSERT INTO nation VALUES ('10', '阿森松岛');
INSERT INTO nation VALUES ('11', '埃及');
INSERT INTO nation VALUES ('12', '埃塞俄比亚');
INSERT INTO nation VALUES ('13', '爱尔兰');
INSERT INTO nation VALUES ('14', '爱沙尼亚');
INSERT INTO nation VALUES ('15', '安道尔');
INSERT INTO nation VALUES ('16', '安哥拉');
INSERT INTO nation VALUES ('17', '安圭拉');
INSERT INTO nation VALUES ('18', '安提瓜岛和巴布达');
INSERT INTO nation VALUES ('19', '奥地利');
INSERT INTO nation VALUES ('20', '奥兰群岛');
INSERT INTO nation VALUES ('21', '澳大利亚');
INSERT INTO nation VALUES ('22', '巴巴多斯岛');
INSERT INTO nation VALUES ('23', '巴布亚新几内亚');
INSERT INTO nation VALUES ('24', '巴哈马');
INSERT INTO nation VALUES ('25', '巴基斯坦');
INSERT INTO nation VALUES ('26', '巴拉圭');
INSERT INTO nation VALUES ('27', '巴勒斯坦');
INSERT INTO nation VALUES ('28', '巴林');
INSERT INTO nation VALUES ('29', '巴拿马');
INSERT INTO nation VALUES ('30', '巴西');
INSERT INTO nation VALUES ('31', '白俄罗斯');
INSERT INTO nation VALUES ('32', '百慕大');
INSERT INTO nation VALUES ('33', '保加利亚');
INSERT INTO nation VALUES ('34', '北马里亚纳群岛');
INSERT INTO nation VALUES ('35', '贝宁');
INSERT INTO nation VALUES ('36', '比利时');
INSERT INTO nation VALUES ('37', '冰岛');
INSERT INTO nation VALUES ('38', '波多黎各');
INSERT INTO nation VALUES ('39', '波兰');
INSERT INTO nation VALUES ('40', '波斯尼亚和黑塞哥维那');
INSERT INTO nation VALUES ('41', '玻利维亚');
INSERT INTO nation VALUES ('42', '伯利兹');
INSERT INTO nation VALUES ('43', '博茨瓦纳');
INSERT INTO nation VALUES ('44', '不丹');
INSERT INTO nation VALUES ('45', '布基纳法索');
INSERT INTO nation VALUES ('46', '布隆迪');
INSERT INTO nation VALUES ('47', '布韦岛');
INSERT INTO nation VALUES ('48', '朝鲜');
INSERT INTO nation VALUES ('49', '丹麦');
INSERT INTO nation VALUES ('50', '德国');
INSERT INTO nation VALUES ('51', '东帝汶');
INSERT INTO nation VALUES ('52', '多哥');
INSERT INTO nation VALUES ('53', '多米尼加');
INSERT INTO nation VALUES ('54', '多米尼加共和国');
INSERT INTO nation VALUES ('55', '俄罗斯');
INSERT INTO nation VALUES ('56', '厄瓜多尔');
INSERT INTO nation VALUES ('57', '厄立特里亚');
INSERT INTO nation VALUES ('58', '法国');
INSERT INTO nation VALUES ('59', '法罗群岛');
INSERT INTO nation VALUES ('60', '法属波利尼西亚');
INSERT INTO nation VALUES ('61', '法属圭亚那');
INSERT INTO nation VALUES ('62', '法属南部领地');
INSERT INTO nation VALUES ('63', '梵蒂冈');
INSERT INTO nation VALUES ('64', '菲律宾');
INSERT INTO nation VALUES ('65', '斐济');
INSERT INTO nation VALUES ('66', '芬兰');
INSERT INTO nation VALUES ('67', '佛得角');
INSERT INTO nation VALUES ('68', '弗兰克群岛');
INSERT INTO nation VALUES ('69', '冈比亚');
INSERT INTO nation VALUES ('70', '刚果');
INSERT INTO nation VALUES ('71', '刚果民主共和国');
INSERT INTO nation VALUES ('72', '哥伦比亚');
INSERT INTO nation VALUES ('73', '哥斯达黎加');
INSERT INTO nation VALUES ('74', '格恩西岛');
INSERT INTO nation VALUES ('75', '格林纳达');
INSERT INTO nation VALUES ('76', '格陵兰');
INSERT INTO nation VALUES ('77', '古巴');
INSERT INTO nation VALUES ('78', '瓜德罗普');
INSERT INTO nation VALUES ('79', '关岛');
INSERT INTO nation VALUES ('80', '圭亚那');
INSERT INTO nation VALUES ('81', '哈萨克斯坦');
INSERT INTO nation VALUES ('82', '海地');
INSERT INTO nation VALUES ('83', '韩国');
INSERT INTO nation VALUES ('84', '荷兰');
INSERT INTO nation VALUES ('85', '荷属安地列斯');
INSERT INTO nation VALUES ('86', '赫德和麦克唐纳群岛');
INSERT INTO nation VALUES ('87', '洪都拉斯');
INSERT INTO nation VALUES ('88', '基里巴斯');
INSERT INTO nation VALUES ('89', '吉布提');
INSERT INTO nation VALUES ('90', '吉尔吉斯斯坦');
INSERT INTO nation VALUES ('91', '几内亚');
INSERT INTO nation VALUES ('92', '几内亚比绍');
INSERT INTO nation VALUES ('93', '加拿大');
INSERT INTO nation VALUES ('94', '加纳');
INSERT INTO nation VALUES ('95', '加蓬');
INSERT INTO nation VALUES ('96', '柬埔寨');
INSERT INTO nation VALUES ('97', '捷克共和国');
INSERT INTO nation VALUES ('98', '津巴布韦');
INSERT INTO nation VALUES ('99', '喀麦隆');
INSERT INTO nation VALUES ('100', '卡塔尔');
INSERT INTO nation VALUES ('101', '开曼群岛');
INSERT INTO nation VALUES ('102', '科科斯群岛');
INSERT INTO nation VALUES ('103', '科摩罗');
INSERT INTO nation VALUES ('104', '科特迪瓦');
INSERT INTO nation VALUES ('105', '科威特');
INSERT INTO nation VALUES ('106', '克罗地亚');
INSERT INTO nation VALUES ('107', '肯尼亚');
INSERT INTO nation VALUES ('108', '库克群岛');
INSERT INTO nation VALUES ('109', '拉脱维亚');
INSERT INTO nation VALUES ('110', '莱索托');
INSERT INTO nation VALUES ('111', '老挝');
INSERT INTO nation VALUES ('112', '黎巴嫩');
INSERT INTO nation VALUES ('113', '立陶宛');
INSERT INTO nation VALUES ('114', '利比里亚');
INSERT INTO nation VALUES ('115', '利比亚');
INSERT INTO nation VALUES ('116', '列支敦士登');
INSERT INTO nation VALUES ('117', '留尼旺岛');
INSERT INTO nation VALUES ('118', '卢森堡');
INSERT INTO nation VALUES ('119', '卢旺达');
INSERT INTO nation VALUES ('120', '罗马尼亚');
INSERT INTO nation VALUES ('121', '马达加斯加');
INSERT INTO nation VALUES ('122', '马尔代夫');
INSERT INTO nation VALUES ('123', '马耳他');
INSERT INTO nation VALUES ('124', '马拉维');
INSERT INTO nation VALUES ('125', '马来西亚');
INSERT INTO nation VALUES ('126', '马里');
INSERT INTO nation VALUES ('127', '马其顿');
INSERT INTO nation VALUES ('128', '马绍尔群岛');
INSERT INTO nation VALUES ('129', '马提尼克');
INSERT INTO nation VALUES ('130', '马约特岛');
INSERT INTO nation VALUES ('131', '曼岛');
INSERT INTO nation VALUES ('132', '毛里求斯');
INSERT INTO nation VALUES ('133', '毛里塔尼亚');
INSERT INTO nation VALUES ('134', '美国');
INSERT INTO nation VALUES ('135', '美属萨摩亚');
INSERT INTO nation VALUES ('136', '美属外岛');
INSERT INTO nation VALUES ('137', '蒙古');
INSERT INTO nation VALUES ('138', '蒙特塞拉特');
INSERT INTO nation VALUES ('139', '孟加拉');
INSERT INTO nation VALUES ('140', '秘鲁');
INSERT INTO nation VALUES ('141', '密克罗尼西亚');
INSERT INTO nation VALUES ('142', '缅甸');
INSERT INTO nation VALUES ('143', '摩尔多瓦');
INSERT INTO nation VALUES ('144', '摩洛哥');
INSERT INTO nation VALUES ('145', '摩纳哥');
INSERT INTO nation VALUES ('146', '莫桑比克');
INSERT INTO nation VALUES ('147', '墨西哥');
INSERT INTO nation VALUES ('148', '纳米比亚');
INSERT INTO nation VALUES ('149', '南非');