mysql 56个民族sql语句

榴莲糖的小城堡

已于 2024-12-19 09:07:48 修改

阅读量229

点赞数

文章标签：经验分享

于 2020-12-17 17:07:36 首次发布

本文链接：https://blog.youkuaiyun.com/qq_37259691/article/details/111319412

版权

建表语句

CREATE TABLE `nation`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `key` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic COMMENT='民族表';

表中数据(数据按照字母表排序)

 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('1' ,'阿昌族' ,'achangzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('2' ,'白族' ,'baizu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('3' ,'保安族' ,'baoanzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('4' ,'布朗族' ,'bulangzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('5' ,'布依族' ,'buyizu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('6' ,'朝鲜族' ,'chaoxianzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('7' ,'德昂族' ,'daangzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('8' ,'傣族' ,'daizu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('9' ,'达斡尔族' ,'dawoerzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('10' ,'东乡族' ,'dongxiangzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('11' ,'侗族' ,'dongzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('12' ,'独龙族' ,'dulongzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('13' ,'鄂伦春族' ,'elunchunzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('14' ,'俄罗斯族' ,'eluosizu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('15' ,'鄂温克族' ,'ewenkezu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('16' ,'高山族' ,'gaoshanzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('17' ,'仡佬族' ,'gelaozu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('18' ,'哈尼族' ,'hanizu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('19' ,'汉族' ,'hanzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('20' ,'哈萨克族' ,'hasakezu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('21' ,'赫哲族' ,'hezhezu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('22' ,'回族' ,'huizu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('23' ,'景颇族' ,'jingpozu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('24' ,'京族' ,'jingzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('25' ,'基诺族' ,'jinuozu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('26' ,'柯尔克孜族' ,'keerkezizu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('27' ,'拉祜族' ,'lahuzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('28' ,'傈僳族' ,'lisuzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('29' ,'黎族' ,'lizu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('30' ,'珞巴族' ,'luobazu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('31' ,'满族' ,'manzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('32' ,'毛南族' ,'maonamzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('33' ,'门巴族' ,'menbazu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('34' ,'蒙古族' ,'mengguzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('35' ,'苗族' ,'miaozu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('36' ,'仫佬族' ,'mulaozu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('37' ,'纳西族' ,'naxizu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('38' ,'怒族' ,'nuzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('39' ,'普米族' ,'pumizu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('40' ,'羌族' ,'qiangzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('41' ,'撒拉族' ,'salazu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('42' ,'畲族' ,'shezu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('43' ,'水族' ,'shuizu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('44' ,'塔吉克族' ,'tajikezu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('45' ,'塔塔尔族' ,'tataerzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('46' ,'土家族' ,'tujiaozu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('47' ,'土族' ,'tuzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('48' ,'佤族' ,'wazu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('49' ,'维吾尔族' ,'weiwuerzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('50' ,'乌孜别克族' ,'wuzibiekezu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('51' ,'锡伯族' ,'xibozu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('52' ,'瑶族' ,'yaozu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('53' ,'彝族' ,'yizu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('54' ,'裕固族' ,'yuguzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('55' ,'藏族' ,'zangzu');
 INSERT INTO `nation`(`id`, `name`, `key`) VALUES ('56' ,'壮族' ,'zhuangzu');