创建数据库，英雄表

insert into t_hero values
(1,"孙悟空","战士","金箍棒","打野"),
(2,"米莱狄","法师","机器人","中路"),
(3,"小乔","法师","扇子","中路"),
(4,"后羿","射手","弓箭","发育路"),
(5,"妲己","法师","尾巴","中路"),
(6,"孙尚香","射手","镰","发育路"),
(7,"鲁班大师","辅助","机械臂","游走路"),
(8,"鲁班七号","射手","炮弹","发育路"),
(9,"项羽","战士","重刀","对抗路"),
(10,"兰陵王","刺客","匕首","打野"),
(11,"鬼谷子","辅助","仗","游走路"),
(12,"赵云","战士","亮银枪","打野"),
(13,"安琪拉","法师","魔法书","中路"),
(14,"白起","战士","镰","对抗路"),
(15,"扁鹊","法师","药瓶","中路"),
(16,"李白","刺客","青莲剑","打野"),
(17,"程咬金","战士","刀","对抗路"),
(18,"狄仁杰","射手","令牌","发育路"),
(19,"姜子牙","辅助","法杖","游走路"),
(20,"典韦","战士","斧","打野"),
(21,"达摩","战士","铁拳","对抗路"),
(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,"孙策","战士","船锚","对抗路"),
(66,"伽罗","射手","弓箭","发育路"),
(67,"上官婉儿","法师","笔","中路"),
(68,"苏烈","战士","柱","游走路"),
(69,"盘古","战士","斧","打野"),
(70,"高渐离","法师","琴","对抗路"),
(71,"云中君","战士","爪","打野"),
(72,"东皇太一","辅助","球","游走路"),
(73,"西施","法师","纱","中路"),
(74,"露娜","战士","刀","打野"),
(75,"杨玉环","法师","琵琶","中路"),
(76,"阿骨朵","战士","熊","打野"),
(77,"云缨","战士","枪","打野"),
(78,"暃","战士","剑","打野"),
(79,"虞姬","射手","弩","发育路"),
(80,"马超","战士","枪","对抗路"),


ALTER TABLE t_hero ADD camp varchar default('三国');
ALTER TABLE campt_hero ADD gender enum('男', '女') default ('男');
 
ALTER TABLE t_hero DROP camp;
t_char
rename table t_hero to t_char