mysql练习2-DML语言

作业：
创建数据库，创建英雄表
添加对应的约束条件
插入80条数据
通过alter添加两个新的字段
通过alter删除一个字段
重命名一张表

创建数据库

创建英雄表，添加对应的约束条件

create table if not exists t_hero(
	id int PRIMARY KEY AUTO_INCREMENT,
	name varchar(100) not null unique,
                nickname varchar(100),
       	tel char(20),
                age int check(age >= 18) default 18,
              	job  varchar(100),
              	weapon varchar(100),
          	group1  varchar(100)            
) ;

插入80条数据

insert into t_hero(id, name,nickname, tel, age,  job,weapon,group1) values(1, "张百川", '玉皇大帝', '200000', '110','god','wu','s');
insert into t_hero(id, name,nickname, tel, age, job,weapon,group1) values(2, "孙悟空", '齐天大圣', '200000', '111','monkey','steak','s');
insert into t_hero(id, name,nickname, tel, age,  job,weapon,group1) values(3, "林妹妹 ", '林黛玉', '20', '112','human','wu','r');

insert into 
t_hero(id, name,nickname, tel, age,  job,weapon,group1)
 values
(40, "史进", '九纹龙', '20567', '29','史家庄少庄','siz','r'),
(41, "朱武", '神机军师', '7890', '42','少华山大寨主','cdf','r'),
(42, "陈达", '跳涧虎', '2367', '27','少华山二寨主','hi','r'),
(43, "杨春", '白花蛇', '8909', '25','少华山三寨主','a','r'),
(44, "鲁智深", '花和尚', '4523', '38','鲁达，提辖','jz','r'),
(45, "李忠", '打虎将', '6790', '28','卖艺、桃花山寨主','gf','r'),
(46 ,"周通", '小霸王', '0876', '38','桃花山寨主','fs','r'),
(47, "林冲", '豹子头', '49063', '29','八十万禁军教头','ju','r'),
(48, "柴进", '小旋风', '67680', '22','柴大官人','md','r'),
(49 ,"杜迁", '摸着天', '33041', '23','原梁山二寨主','hy','r'),
(50,"朱贵", '旱地忽律', '6569', '26','梁山耳目','jd','r'),
(51,"宋万", '云里金刚', '6779', '28','原梁山三寨主','kd','r'),
(52,"杨志", '青面兽', '1231', '30','殿司制使官，管军提辖使','yy','r'),
(53,"索超", '急先锋', '65269', '26','管军提辖使','nd','r'),
(54,"朱仝", '美髯公', '61779', '38','郓城马兵都头','cq','r'),
(55,"吴用", '智多星', '41231', '20','表字学究','hs','r');

通过alter添加两个新的字段

通过alter删除一个字段

重命名一张表