SQL常用命令集3

11 创建视图

CREATE VIEW is_student AS SELECT Sno, Sname, Sage from student WHERE Sdept='IS';
create view S_G(Sno, Gavg) AS select Sno, AVG(Grade) from SC GROUP by Sno;

 

 

12 查询视图

select * from S_G where Gavg>=86;

 

 

13 更新视图

update is_student SET Sname='刘琛' where Sno='95002';

 

14 增加用户权限

grant select, insert, update, delete on school.* to suser@"%" identified by "suser";

 

15 删除用户权限 

revoke select on school.student from suser1@"%";