MySQL第二次作业

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

一、

create database db_classics;
use db_classics;
create table t_hero(
    id int,
    name varchar(10),
    nickname varchar(10),
    age int, 
    address text,
    job  varchar(10),
    weapon varchar(10),
    groupname varchar(10)
);

insert into t_hero values(1,"孙悟空","齐天大圣","50000","花果山","弼马温","如意金箍棒","妖族");
insert into t_hero values(2,"赵云","常山赵子龙","66","常山","五虎上将","百鸟朝凤枪","蜀国");
insert into t_hero values(3,"林冲","豹子头","56","汴梁","八十万禁军总教头","长枪","梁山");

二、
create table t_wzry(
    id int primary key auto_increment,
    name varchar(50) not null unique,
    gender varchar(10) default "男",
    occupation varchar(50) not null,
    weapon varchar(50) default "刀"
);

insert into t_wzry values(1,"李白","男","刺客","剑");
insert into t_wzry values(2,"宫本武藏","男","战士","剑");
insert into t_wzry values(3,"李信","男","战士","剑");
insert into t_wzry values(4,"韩信","男","战士","枪");
insert into t_wzry values(5,"孙悟空","男","战士","棍");
insert into t_wzry values(6,"阿珂","女","刺客","短刀");
insert into t_wzry values(7,"百里玄策","男","刺客","飞镰");
insert into t_wzry values(8,"百里守约","男","射手","枪");
insert into t_wzry values(9,"苏烈","男","坦克","柱");
insert into t_wzry values(10,"花木兰","女","战士","剑");
insert into t_wzry values(11,"铠","男","坦克","刀");
insert into t_wzry values(11,"芈月","女","法师","法杖");
insert into t_wzry values(12,"夏洛特","女","战士","剑");
insert into t_wzry values(13,"李元芳","男","射手","飞镖");
insert into t_wzry values(14,"曹操","男","战士","剑");
insert into t_wzry values(15,"狄仁杰","男","射手","令牌");
insert into t_wzry values(16,"武则天","女","法师","法典");
insert into t_wzry values(17,"干将莫邪","男","法师","剑");
insert into t_wzry values(18,"诸葛亮","男","法师","法书");
insert into t_wzry values(19,"廉颇","男","坦克","盾牌");
insert into t_wzry values(20,"白起","男","坦克","镰刀");
insert into t_wzry values(21,"周瑜","男","法师","法典");
insert into t_wzry values(22,"司马懿","男","法师","法典");
insert into t_wzry values(23,"元歌","男","刺客","傀儡");
insert into t_wzry values(24,"吕布","男","战士","方天画戟");
insert into t_wzry values(25,"赵云","男","战士","枪");
insert into t_wzry values(26,"貂蝉","女","法师","法典");
insert into t_wzry values(27,"蔡文姬","女","辅助","法典");
insert into t_wzry values(28,"孙膑","女","辅助","法术");
insert into t_wzry values(29,"澜","男","刺客","双刀");
insert into t_wzry values(30,"曜","男","战士","剑");
insert into t_wzry values(31,"镜","男","刺客","短刀");
insert into t_wzry values(32,"刘备","男","战士","枪");
insert into t_wzry values(33,"张飞","男","辅助","矛");
insert into t_wzry values(34,"关羽","男","战士","大刀");
insert into t_wzry values(35,"孙策","男","战士","舵");
insert into t_wzry values(36,"大乔","女","辅助","法杖");
insert into t_wzry values(37,"小乔","女","法师","扇子");
insert into t_wzry values(38,"孙尚香","女","射手","枪");
insert into t_wzry values(39,"伽罗","女","射手","弓箭");
insert into t_wzry values(40,"太乙真人","男","辅助","炉子");
insert into t_wzry values(41,"钟馗","男","辅助","飞钩");
insert into t_wzry values(42,"亚连","男","战士","剑");
insert into t_wzry values(43,"姬小满","女","战士","拳头");
insert into t_wzry values(44,"安琪拉","女","法师","法典");
insert into t_wzry values(45,"甄姬","女","法师","法书");
insert into t_wzry values(46,"马超","男","战士","枪");
insert into t_wzry values(47,"典韦","男","战士","斧头");
insert into t_wzry values(48,"鲁班七号","男","射手","枪");
insert into t_wzry values(49,"鬼谷子","男","辅助","法杖");
insert into t_wzry values(50,"东皇太一","男","辅助","法典");
insert into t_wzry values(51,"明世隐","男","辅助","法杖");
insert into t_wzry values(52,"庄周","男","辅助","鲲");
insert into t_wzry values(53,"米莱迪","女","法师","法杖");
insert into t_wzry values(54,"司空震","男","法师","拳头");
insert into t_wzry values(55,"金蝉","男","法师","法杖");
insert into t_wzry values(56,"虞姬","女","射手","弓弩");
insert into t_wzry values(57,"钟无艳","女","战士","大锤");
insert into t_wzry values(58,"扁鹊","男","法师","法典");
insert into t_wzry values(59,"蒙玡","男","法师","火箭弹");
insert into t_wzry values(60,"云缨","女","战士","长枪");
insert into t_wzry values(61,"西施","女","法师","法典");
insert into t_wzry values(62,"成吉思汗","男","射手","弓箭");
insert into t_wzry values(63,"女娲","女","法师","法典");
insert into t_wzry values(64,"阿古朵","女","战士","熊猫");
insert into t_wzry values(65,"梦琪","男","战士","泡泡");
insert into t_wzry values(66,"戈雅","女","射手","摩托");
insert into t_wzry values(67,"瑶","女","辅助","法杖");
insert into t_wzry values(68,"马可波罗","男","射手","枪");
insert into t_wzry values(69,"牛魔","男","坦克","斧头");
insert into t_wzry values(70,"嫦娥","女","法师","法典");
insert into t_wzry values(71,"黄忠","男","射手","大炮");
insert into t_wzry values(72,"刘禅","男","辅助","机甲");
insert into t_wzry values(73,"盘古","男","战士","斧头");
insert into t_wzry values(74,"杨玉环","女","法师","二胡");
insert into t_wzry values(75,"妲己","女","法师","法典");
insert into t_wzry values(76,"盾山","男","辅助","盾牌");
insert into t_wzry values(77,"亚瑟","男","战士","剑");
insert into t_wzry values(78,"赵怀真","男","战士","拳头");
insert into t_wzry values(79,"露娜","女","刺客","剑");
insert into t_wzry values(80,"橘右京","男","刺客","剑");

alter table t_wzry add dynasty varchar(10) default "不详";
alter table t_wzry add shunt varchar(10) default "混子";
alter table t_wzry drop gender;
alter table t_wzry rename t_wzrys;