1.创建test数据库
create database test character set utf8;
2.在test数据库中创建student表,(id设置为主键自增长)
create table student(
id int primary key auto_increment,
name varchar(20),
score int,
address varchar(50),
useremail varchar(20)
)
desc student;
3.向student表中添加记录
insert into student value(1,'张三',98,'北京','111111111@qq.com'),(2,'李四',88,'上海','111111112@qq.com'),(3,'王五',78,'广州','111111113@qq.com'),(4,'赵六',68,'深圳','111111114@qq.com'),(5,'孙七',58,'杭州','111111115@qq.com'),(6,'小红',48,'北京','111111116@qq.com'),(7,'小黑',99,'上海','111111117@qq.com'),(8,'小绿',100,'杭州','111111118@qq.com&