56个民族静态字典代码创建sql语句

 

 

   创建静态字典代码数据库表

DROP TABLE IF EXISTS `zddm_common`;

CREATE TABLE `zddm_common` (
  `zdlb` varchar(10) NOT NULL,
  `zddm` varchar(10) NOT NULL,
  `zdms` varchar(100) NOT NULL,
  `xxms` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`zdlb`,`zddm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

 

 

 

   插入56个民族的信息：

insert  into `zddm_common`(`zdlb`,`zddm`,`zdms`,`xxms`) values ('mz','东乡族','东乡族',NULL),('mz','乌兹别克族','乌兹别克族',''),('mz','京族','京族',NULL),('mz','仡佬族','仡佬族',NULL),('mz','仫佬族','仫佬族',''),('mz','佤族','佤族',''),('mz','侗族','侗族',NULL),('mz','俄罗斯族','俄罗斯族',NULL),('mz','保安族','保安族',''),('mz','傈僳族','傈僳族',''),('mz','傣族','傣族',NULL),('mz','哈尼族','哈尼族',NULL),('mz','哈萨克族','哈萨克族',NULL),('mz','回族','回族',NULL),('mz','土家族','土家族',''),('mz','土族','土族',''),('mz','基诺族','基诺族',NULL),('mz','塔吉克族','塔吉克族',''),('mz','塔塔尔族\r\n','塔塔尔族',NULL),('mz','塔塔尔族','塔塔尔族',''),('mz','壮族','壮族',''),('mz','布依族','布依族',NULL),('mz','布朗族','布朗族',NULL),('mz','彝族','彝族',''),('mz','德昂族','德昂族',NULL),('mz','怒族','怒族',''),('mz','拉祜族','拉祜族',''),('mz','撒拉族','撒拉族',''),('mz','普米族','普米族',''),('mz','景颇族','景颇族',NULL),('mz','朝鲜族','朝鲜族',NULL),('mz','柯尔克孜族','柯尔克孜族',NULL),('mz','毛南族','毛南族',''),('mz','水族','水族',''),('mz','汉族','汉族','民族'),('mz','满族','满族',''),('mz','独龙族','独龙族',''),('mz','珞巴族','珞巴族',''),('mz','瑶族','瑶族',''),('mz','畲族','畲族',''),('mz','白族','白族',NULL),('mz','纳西族','纳西族',''),('mz','维吾尔族','维吾尔族',''),('mz','羌族','羌族',''),('mz','苗族','苗族',''),('mz','蒙古族','蒙古族',''),('mz','裕固族','裕固族',''),('mz','赫哲族','赫哲族',NULL),('mz','达斡尔族','达斡尔族',NULL),('mz','鄂伦春族','鄂伦春族',NULL),('mz','鄂温克族','鄂温克族',NULL),('mz','锡伯族','锡伯族',''),('mz','门巴族','门巴族',''),('mz','阿昌族','阿昌族',NULL),('mz','高山族','高山族',NULL),('mz','黎族','黎族','');