, , , . SQL GRANT REVOKE, . , . ( ), , , . , SQL ().
SQL ( , ). . GRANT. GRANT :
GRANT {< > | ALL PRIVILEGES} ON < >
TO {< > | PUBLIC} [WITH GRANT OPTIONS]
SQL :
SELECT ;
INSERT [< >] ;
UPDATE [< >] ;
DELETE ;
REFERENCE [< >] ;
USAGE .
WITH GRANT OPTIONS, . , , .
REVOKE:
REVOKE [GRANT OPTION FOR] {< > | ALL PRIVILEGES}
ON < >
FROM {< > | PUBLIC} [RESTRICT | CASCADE]
GRANT OPTION FOR .
|
5.1. SQL: .
5.2. SQL.
5.3. SQL.
5.4. SQL.
5.5. () :
SELECT , , FROM INNER JOIN AS = SORT BY WHERE = ;
5.6. ( ):
DELETE * FROM INNER JOIN ON . = .;
|
|
|
a) , ;
b) ( ) ;
c) , .
5.7. () . : , , .
5.8. .
5.9. .
5.10. , , SQL. . .
5.11. :
SELECT , SUM(*) FROM INNER JOIN ON . = . WHERE EXISTS(SELECT * FROM WHERE = And . = .) GROUP BY ;
5.12. ( ):
SELECT * FROM , ;
d) , ,
e) , ,
f) .
5.13. SQL.
5.14. SQL.
5.15. .
5.16. SQL.
5.17. SQL.
5.18. SQL.
