create table teachar(
id int primary key auto_increment,
name varchar(255),
score int,
address varchar(255),
usermail varchar(255)
)
insert into teachar values
(null,'张三',88,'北京','111111111@qq.com'),
(NULL,'李四',98,'上海','111111112@qq.com'),
(null,'王五',78,'广州','111111113@qq.com'),
(null,'赵六',68,'深圳','111111114@qq.com'),
(null,'孙七',58,'北京','111111115@qq.com'),
(null,'小红',67,'杭州','111111116@qq.com')
-- 4.使用sql语句查询出表中的所有内容
select * from teachar
-- 5.使用sql语句查询出表中所有score>70的同学的id,name,score
select id,name,score from teachar where score>70;
-- 6.更改name字段的数据类型为varchar(50)
alter table teachar MODIFY column name varchar(50)
-- 7.向表中添加一个字段,字段名称为“pingjia”,字段类型为varchar(20)
alter table