中国56个民族脚本数据

– 建表语句

DROP TABLE IF EXISTS `nation`;
CREATE TABLE `nation`  (
                           `CODE_` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '代码',
                           `NATION_` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '民族',
                           `TYPE_` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '有无叶子节点：0代表无，1代表有',
                           PRIMARY KEY (`CODE_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

– 56个民族数据

INSERT INTO `nation` (`CODE_`,`NATION_`,`TYPE_`) VALUES ('01', '汉族', '0'),
('02', '蒙古族', '0'),
('03', '回族', '0'),
('04', '藏族', '0'),
('05', '维吾尔族', '0'),
('06', '苗族', '0'),
('07', '彝族', '0'),
('08', '壮族', '0'),
('09', '布依族', '0'),
('10', '朝鲜族', '0'),
('11', '满族', '0'),
('12', '侗族', '0'),
('13', '瑶族', '0'),
('14', '白族', '0'),
('15', '土家族', '0'),
('16', '哈尼族', '0'),
('17', '哈萨克族', '0'),
('18', '傣族', '0'),
('19', '黎族', '0'),
('20', '傈僳族', '0'),
('21', '佤族', '0'),
('22', '畲族', '0'),
('23', '高山族', '0'),
('24', '拉祜族', '0'),
('25', '水族', '0'),
('26', '东乡族', '0'),
('27', '纳西族', '0'),
('28', '景颇族', '0'),
('29', '柯尔克孜族', '0'),
('30', '土族', '0'),
('31', '达斡尔族', '0'),
('32', '仫佬族', '0'),
('33', '羌族', '0'),
('34', '布朗族', '0'),
('35', '撒拉族', '0'),
('36', '毛难族', '0'),
('37', '仡佬族', '0'),
('38', '锡伯族', '0'),
('39', '阿昌族', '0'),
('40', '普米族', '0'),
('41', '塔吉克族', '0'),
('42', '怒族', '0'),
('43', '乌孜别克族', '0'),
('44', '俄罗斯族', '0'),
('45', '鄂温克族', '0'),
('46', '崩龙族', '0'),
('47', '保安族', '0'),
('48', '裕固族', '0'),
('49', '京族', '0'),
('50', '塔塔尔族', '0'),
('51', '独龙族', '0'),
('52', '鄂伦春族', '0'),
('53', '赫哲族', '0'),
('54', '门巴族', '0'),
('55', '珞巴族', '0'),
('56', '基诺族', '0');