第三次作业

在数据库中创建一个表student，用于存储学生信息

CREATE TABLE student(
    id INT PRIMARY KEY,
    name VARCHAR(20) NOT NULL,
    grade FLOAT
);

1、向student表中添加一条新记录
    记录中id字段的值为1，name字段的值为"monkey"，grade字段的值为98.5

insert student values(1,'monkey',98.5);

2、向student表中添加多条新记录
    2,"bob",95.5
    3,"john",90.0
    4,"smith",88.5

mysql> insert student values(2,'bob',90.5);

mysql> insert student values(3,'john',90.0);

mysql> insert student values(4,'smith',88.5);

#一次插入多条数据
insert student values(2,'bob',90.5),(3,'john',90.0),(4,'smith',88.5);

3、向student表中添加一条新记录，部分数据插入 5,"jone"

insert student values(5,'jone');

4、更新表，grade 大于90的加0.5

update student set grade=grade+0.5 where grade>90;

5、删除成绩为空的记录

delete from student where grade is null;