数据库day 2

作业：
创建数据库，创建英雄表,添加对应的约束条件

create database db_yingxiong;
use db_yingxiong;
create table if not exists t_hero(
		id int primary key auto_increment,
		name varchar(50) not null unique,
		gender varchar(10) default "男",
		# gender enum("男", "女") default "男",
		age int check(age >= 18) default 18,
		tel char(20)
	)engine=innodb;

插入80条数据

insert into t_hero values(1, "曹操", "男", 43, '182');
insert into t_hero values(2, "刘备", "男", 36, '160');
insert into t_hero values(3, "孙权", "男", 40, '173');
insert into t_hero values(4, "诸葛亮", "男", 35, '193');
insert into t_hero values(5, "貂蝉", "女", 23, '170');
insert into t_hero values(6, "关羽", "男", 40, '187');
insert into t_hero values(7, "张飞", "男", 39, '188');
insert into t_hero values(8, "赵云", "男", 35, '187');
insert into t_hero values(9, "黄月英", "女", 33, '157');
insert into t_hero values(10, "大乔", "女", 36, '155');
.......

通过alter添加两个新的字段

alter table t_hero add address varchar(100);
alter table t_hero add job varchar(150);

通过alter删除一个字段

alter table t_hero drop job;

重命名一张表

alter table t_hero rename t_yx;