数据库创建英雄(hero)表

创建数据库:
 create databases classics;

创建英雄表,添加对应的约束条件
 create table t_hero(
      id int primary key,
      name varchar(50) not null,
      nickname varchar(50),
      age int,
      address varchar(30),
      job varchar(20),
      weapon varchar(20)
  );

插入80条数据

 insert into t_hero(id, name,nickname, age, weapon,job) values
(1, "白起", "战士",'2000', '镰');
(2,"扁鹊","法师",'200',"药瓶","中路"),
(3,"程咬金","战士",'3000',"刀","对抗路"),
(4,"妲己","法师",'450',"尾巴","中路"),
 insert into t_hero(id, name,nickname, age, weapon,job) values
(5,"狄仁杰","射手",'5600',"令牌","发育路"),
(6,"典韦","战士",'250',"斧","打野"),
(7,"高渐离","法师",'5000',"琴","对抗路"),
(8,"韩信","刺客",'400',"长枪","打野"),
(9,"荆轲","刺客",'700',"匕首","打野"),
(10,"老夫子","战士",'750',"长棍","对抗路"),
(11,"刘禅","坦克",'555',"机械臂","游走路"),
(12,"孙膑","战士",'800',"轮盘","游走"),

  insert into t_hero(id, name,nickname, weapon,job) values
(22,"亚瑟","战士","盾牌","对抗路"),
(23,"安琪拉","法师","魔法书","中路"),
(24,"露娜","战士","刀刃","打野"),
(25,"曹操","战士","刀","对抗路"),
(26,"后羿","射手","弓箭","发育路"),
(27,"孙悟空","战士","金箍棒","打野"),
(28,"貂蝉","法师","莲花","中路"),
(29,"刘备","战士","弩炮","打野"),
(30,"花木兰","战士","长剑","对抗路"),
(31,"李元芳","射手","飞镖","发育路"),
(32,"李白","刺客","青莲剑","打野"),
(33,"兰陵王","刺客","匕","打野"),
(34,"钟馗","辅助","长钩","游走路"),
(35,"不知火舞","法师","火扇","中路"),
(36,"虞姬","射手","弩","发育路"),
(37,"牛魔","坦克","斧","游走路"),
(38,"关羽","战士","长刀","对抗路"),
(39,"马可波罗","射手","枪","发育路"),
(40,"杨戬","战士","戟","对抗路"),
(41,"太乙真人","辅助","药炉","游走路"),
(42,"诸葛亮","法师","羽扇","中路"),
(43,"黄忠","战士","炮","发育路"),
(44,"大乔","辅助","灯笼","游走路"),
(45,"东皇太一","辅助","球","游走路"),
(46,"鬼谷子","辅助","仗","游走路"),
(47,"铠","战士","刀剑","打野"),
(48,"百里守约","射手","枪","发育路"),
(49,"百里玄策","战士","镰","打野"),
(50,"周瑜","法师","火","中路"),
(51,"苏烈","战士","柱","游走路"),
(52,"公孙离","射手","伞","发育路"),
(53,"杨玉环","法师","琵琶","中路"),
(54,"裴擒虎","战士","拳","打野"),
(55,"弈星","法师","棋盘","中路"),
(56,"米莱狄","法师","机器人","中路"),
(57,"孙策","战士","船锚","对抗路"),
(58,"伽罗","射手","弓箭","发育路"),
(59,"上官婉儿","法师","笔","中路"),
(60,"嫦娥","法师","兔子","中路"),
(61,"猪八戒","坦克","钯","对抗路"),
(62,"盘古","战士","斧","打野"),
(63,"瑶","辅助","杖","游走路"),
(64,"云中君","战士","爪","打野"),
(65,"马超","战士","枪","对抗路"),

insert into t_hero(id, name,nickname, age, weapon,job) values
(66,"西施","法师",'890',"纱","中路"),
(67,"鲁班大师","辅助",'7000',"机械臂","游走路"),
(68,"镜","刺客",'4500',"刃","打野"),
(69,"蒙恬","战士",'12',"盾矛","对抗路"),
(70,"阿骨朵","战士",'980',"熊","打野"),
(71,"夏洛特","战士",'3000',"剑","对抗路"),
(72,"澜","刺客",'5000',"匕","打野"),
(73,"云缨","战士",'9230',"枪","打野"),
(74,"金蝉","法师",'1200',"锡杖","中路"),
(75,"暃","战士",'500',"剑","打野"),
(76,"戈娅","射手",'901',"弩","发育路"),
(77,"海月","法师",'9',"月","中路"),
(78,"赵怀真","战士",'700',"拳","打野"),
(79,"莱西奥","射手",'6700',"炮","发育路"),
(80,"亚连","战士",'9008',"刃","对抗路");

通过alter添加两个新的字段

添加gender这一列
ALTER TABLE campt_hero ADD gender enum('男', '女') default ('男');

通过alter删除一个字段
重命名一张表