【无标题】

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

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

1、向student表中添加一条新记录
记录中id字段的值为1，name字段的值为"monkey"，grade字段的值为98.5
2、向student表中添加多条新记录
2,“bob”,95.5
3,“john”,90.0
4,“smith”,88.5
3、向student表中添加一条新记录，部分数据插入
5,“jone”
4、更新表，grade 大于90的加0.5
5、删除成绩为空的记录
mysql> use db_system ;
Database changed
mysql> create table studet(
-> id int primary key,
-> name varchar(20) not null,
-> grade float
-> );
Query OK, 0 rows affected (0.01 sec)
mysql> insert into studet values (1,‘monkeys’,98.5) ;
Query OK, 1 row affected (0.00 sec)
mysql> insert into studet (id,name,grade) values(2,‘bob’,95.5),(3,‘john’,90.0),(4,‘smith’,88.5);
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> insert studet(id,name) values(5,‘jone’);
Query OK, 1 row affected (0.00 sec)
mysql> select * from studet;
±—±--------±------+
| id | name | grade |
±—±--------±------+
| 1 | monkeys | 98.5 |
| 2 | bob | 95.5 |
| 3 | john | 90 |
| 4 | smith | 88.5 |
| 5 | jone | NULL |
±—±--------±------+
5 rows in set (0.00 sec)
mysql> update studet set grade=grade+0.5 where grade>90;
mysql> delete from student where grade is null ;
Query OK, 0 rows affected (0.00 sec)

二、用户权限部分
1、创建一个用户test1使他只能本地登录拥有查询student表的权限。
2、查询用户test1的权限。
3、删除用户test1.
mysql> create user ‘test1’@‘%’ identified by ‘test1’;
Query OK, 0 rows affected (0.02 sec)

mysql> grant select on db_system.studet to test1
-> ;
Query OK, 0 rows affected (0.00 sec)

mysql> drop user ‘test1’@‘%’;
Query OK, 0 rows affected (0.00 sec)