数据库第二次作业

创建一个英雄表(hero)
主键
name
nickname
address
groups
email
telphone

 1.创建作业数据库

create database zuoye;

 2.使用数据库

use zuoye;

 

3.创建英雄表(hero)

-- 建一个英雄表(hero)
CREATE TABLE hero(
	id int primary key auto_increment comment 'id唯一标识',
	name varchar(20) comment '四大名著' ,
	nickname varchar(50) comment '英雄昵称' ,
	address varchar(50) comment '地址',
	gruops varchar(50) comment '小组',
	email varchar(200) comment '邮件',
	telephone varchar(200) comment '电话'
);

4.查询已经创建好的表

-- 查询已经创建好的表
select * from hero;

 

5.插入数据

-- 插入数据
insert into hero VALUES
	(1,"西游记","孙悟空","花果山","取经小组",'54188@qq.com','54188'),
	(2,"西游记","沙和尚","流沙河","取经小组",'66666@qq.com','66666'),
	(3,"三国演义","诸葛亮","南阳草庐","蜀国",'58588@qq.com','58588'),
	(4,"三国演义","孙权","江东","江东鼠辈",'100000@qq.com','100000'),
	(5,"水浒传","鲁智深","寺庙","梁山贼寇",'99999@qq.com','99999'),
	(6,"红楼梦","林黛玉","家里","倒把垂杨柳小组",'88888@qq.com','88888');

6.查询插入的数据

-- 查询插入的数据
select * from hero;