56个民族 sql

　

56个民族

创建表结构

CREATE TABLE `teacher_nation` (
`mz_id` int(11) NOT NULL AUTO_INCREMENT,
  `mzname` varchar(20) NOT NULL,
  PRIMARY KEY (`mz_id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8;

民族信息入库

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

相关阅读

sql 不等于符号

sql中的等于和不等于， ‘=’ ,’!=’,’<>’,‘is null’<> ：不等于例子，select * from bl_ip_dt where amount <> 800,这条语句查

Mysql配置文件my.cnf配置及配置参数详解

Mysql配置文件my.cnf 安装了mysql没有my.cnf文件的情况 1、可以把mysql的示例配置文件，如my-medium.cnf拷贝到/etc/my.cnf，再去修改

sqlprompt

把Oracle sqlplus提示符修改为如下，可以提醒你所在的用户模式，减少误操作。 set sqlprompt user;

sql server 中游标

我们先不讲游标的什么概念，步骤及语法，先来看一个例子：         表一 OriginSalary                  

SQL内连接与外连接

1.概述 1、内联接（典型的联接运算，使用像 = 或 <> 之类的比较运算符）。包括相等联接和自然联接。内联接使用比较运算符根据每个表共