第三次作业

mysql> use db_system
Database changed
mysql> create table student(
    -> id int primary key,
    -> name varchar(20) not null,
    -> grade float
    -> );
Query OK, 0 rows affected (0.03 sec)

mysql> insert student (id,name,grade) values (1,'monkey',98.5);
Query OK, 1 row affected (0.03 sec)

mysql> insert student values (2,'bob',95.5),
    -> (3,'john',90.0),
    -> (4,'smith',88.5);
Query OK, 3 rows affected (0.03 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> insert student(id,name) values (5,'jone');
Query OK, 1 row affected (0.01 sec)

mysql> update student
    -> set grade =grade + 0.5
    -> where grade > 90;
Query OK, 2 rows affected (0.01 sec)
Rows matched: 2  Changed: 2  Warnings: 0

mysql> delete from student where grade is null;
Query OK, 1 row affected (0.01 sec)