创建一个英雄表(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;