MySQL创建民族表的SQL语句
MySQL创建民族表的SQL语句
1 CREATE TABLE `nation` ( 2 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3 `nation` varchar(30) NOT NULL DEFAULT '', 4 PRIMARY KEY (`id`) 5 ) ENGINE=MyISAM AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='民族表'; 6
7 -- ----------------------------
8 -- Records of nation
9 -- ----------------------------
10 INSERT INTO `nation` VALUES ('1', '汉族'); 11 INSERT INTO `nation` VALUES ('2', '蒙古族'); 12 INSERT INTO `nation` VALUES ('3', '回族'); 13 INSERT INTO `nation` VALUES ('4', '藏族'); 14 INSERT INTO `nation` VALUES ('5', '维吾尔族'); 15 INSERT INTO `nation` VALUES ('6', '苗族'); 16 INSERT INTO `nation` VALUES ('7', '彝族'); 17 INSERT INTO `nation` VALUES ('8', '壮族'); 18 INSERT INTO `nation` VALUES ('9', '布依族'); 19 INSERT INTO `nation` VALUES ('10', '朝鲜族'); 20 INSERT INTO `nation` VALUES ('11', '满族'); 21 INSERT INTO `nation` VALUES ('12', '侗族'); 22 INSERT INTO `nation` VALUES ('13', '瑶族'); 23 INSERT INTO `nation` VALUES ('14', '白族'); 24 INSERT INTO `nation` VALUES ('15', '土家族'); 25 INSERT INTO `nation` VALUES ('16', '哈尼族'); 26 INSERT INTO `nation` VALUES ('17', '哈萨克族'); 27 INSERT INTO `nation` VALUES ('18', '傣族'); 28 INSERT INTO `nation` VALUES ('19', '黎族'); 29 INSERT INTO `nation` VALUES ('20', '傈僳族'); 30 INSERT INTO `nation` VALUES ('21', '佤族'); 31 INSERT INTO `nation` VALUES ('22', '畲族'); 32 INSERT INTO `nation` VALUES ('23', '高山族'); 33 INSERT INTO `nation` VALUES ('24', '拉祜族'); 34 INSERT INTO `nation` VALUES ('25', '水族'); 35 INSERT INTO `nation` VALUES ('26', '东乡族'); 36 INSERT INTO `nation` VALUES ('27', '纳西族'); 37 INSERT INTO `nation` VALUES ('28', '景颇族'); 38 INSERT INTO `nation` VALUES ('29', '柯尔克孜族'); 39 INSERT INTO `nation` VALUES ('30', '土族'); 40 INSERT INTO `nation` VALUES ('31', '达斡尔族'); 41 INSERT INTO `nation` VALUES ('32', '仫佬族'); 42 INSERT INTO `nation` VALUES ('33', '羌族'); 43 INSERT INTO `nation` VALUES ('34', ' 布朗族'); 44 INSERT INTO `nation` VALUES ('35', ' 撒拉族'); 45 INSERT INTO `nation` VALUES ('36', ' 毛难族'); 46 INSERT INTO `nation` VALUES ('37', ' 仡佬族'); 47 INSERT INTO `nation` VALUES ('38', ' 锡伯族'); 48 INSERT INTO `nation` VALUES ('39', ' 阿昌族'); 49 INSERT INTO `nation` VALUES ('40', ' 普米族'); 50 INSERT INTO `nation` VALUES ('41', ' 塔吉克族'); 51 INSERT INTO `nation` VALUES ('42', ' 怒族'); 52 INSERT INTO `nation` VALUES ('43', ' 乌孜别克族'); 53 INSERT INTO `nation` VALUES ('44', ' 俄罗斯族'); 54 INSERT INTO `nation` VALUES ('45', ' 鄂温克族'); 55 INSERT INTO `nation` VALUES ('46', ' 崩龙族'); 56 INSERT INTO `nation` VALUES ('47', ' 保安族'); 57 INSERT INTO `nation` VALUES ('48', ' 裕固族'); 58 INSERT INTO `nation` VALUES ('49', ' 京族'); 59 INSERT INTO `nation` VALUES ('50', ' 塔塔尔族'); 60 INSERT INTO `nation` VALUES ('51', ' 独龙族'); 61 INSERT INTO `nation` VALUES ('52', ' 鄂伦春族'); 62 INSERT INTO `nation` VALUES ('53', ' 赫哲族'); 63 INSERT INTO `nation` VALUES ('54', ' 门巴族'); 64 INSERT INTO `nation` VALUES ('55', ' 珞巴族'); 65 INSERT INTO `nation` VALUES ('56', ' 基诺族');
更多精彩
