MySQL（3）小练习

####数据相关练习
#1. 创建hero表 id 名字name 类型type  价格money
use king;
create table hero(
id int,
name varchar(20),
type varchar(10),
money int
);
select * from hero;
#2. 保存以下数据
#	1,'诸葛亮','法师',18888 2,'周瑜','法师',13888
#	3,'孙悟空','打野',18888 4,'小乔','法师',13888
#	5,'黄忠','射手',8888 6,'刘备','战士',6888
insert into hero values(1,"诸葛亮","法师",18888),(2,"周瑜","法师",13888),(3,"孙悟空","打野",18888),(4,"小乔","法师",13888),(5,"黄忠","射手",8888);
insert into hero(id,name,type,money) values(6,"刘备","战士",6888);
#3. 修改所有18888为28888
update hero set money=28888 where money=18888;
#4. 修改所有法师为战士
update hero set type="战士" where type="法师";
#5. 删除价格为6888的英雄
delete from hero where money=68888;
#6. 修改小乔为猪八戒
update hero set name="猪八戒" where name="小乔";
#7. 删除价格低于15000的英雄
delete from hero where money<15000;
#8. 添加性别gender字段在name的后面
alter table hero add gender varchar(2) after name;
#9. 修改所有英雄的性别为男
update hero set gender="男";
#10. 删除所有数据
delete from hero ;
#11. 删除表
drop table hero;

ps:我们老师出的练习题，老师姓赵，人很好