使用MySQL数据库创建表

数据库创建表"/>

使用MySQL数据库创建表

创建一个数据，db_classics
    创建一张表：t_hero

    id name nickname age address job  weapon group
    1 张百川 玉皇大帝 200000        
    2 孙悟空  齐天大圣 
    3 林妹妹 

create database db_classics;use db_classics;create tablet_hero(	
id int primary key,
name varchar(50) not null,
nickname varchar(50),
age int,
address varchar(30),
job varchar(20),
weapon varchar(20),
group varchar(10)
);insert into t_hero values
(1,"张百川","玉皇大帝",20000,'仙界','老板','照妖镜','仙'),
(2,"孙悟空","齐天大圣",666,'花果山','保镖','金箍棒','妖'),
(3,"林黛玉","金陵十二钗",18,'潇湘馆','才女','才华','人');drop table t_hero;

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

创建一张王者荣耀英雄表create table if not exists t_hero(id int primary key,name varchar(30) not null,identity varchar(50) default('法师'),weapon varchar(50) default('剑'),Shunt varchar(50) default('对抗路')
); 插入80个英雄数据
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,"亚连","战士","刃","对抗路");添加camp这一列
ALTER TABLE t_hero ADD camp varchar default('三国');
添加gender这一列
ALTER TABLE campt_hero ADD gender enum('男', '女') default ('男');删除camp这一列
ALTER TABLE t_hero DROP camp;
重命名表为t_character
rename table t_hero to t_character