中国56民族 sql

心已赠人 2022-05-11 05:48 172阅读 0赞

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