关于 世界各国 省份 城市 三级数据库表脚本文件

注：其中省份城市目前只有中国的。

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', '南非');