.1.3 , . , - , , , . . , , SQL- .
CREATE VIEW
CREATE VIEW _
[([,]...)]
AS
[WITH CHECK OPTION];
, AS , , ;
"WITH CHECK OPTION" ( ) , INSERT UPDATE - , WHERE ;
, :
) ( , SQL- );
) ;
, .
, _
CREATE VIEW _
AS SELECT , , ,
FROM
WHERE = '';
.
DROP VIEW ( ), :
DROP VIEW ;
5.4.2.
_ , , , :
SELECT *
FROM _;
, , :
CREATE VIEW __
AS SELECT , ,
FROM _, ,
WHERE _. = .
AND . = .
AND = '';
, ,
SELECT , ,
FROM __
WHERE IN
(SELECT
FROM __
WHERE = '')
:
, , , , SELECT, . ( SELECT SELECT , ).
|
|
5.4.3.
.4 DELETE, INSERT UPDATE , . , , , , .
, () , "- ". _, , '' . , :
- ( INSERT) , , (34, '', '', 150), (34, '', '', 150, NULL) ;
- ( DELETE) , (13, '', '', 300), (13, '', '', 300, 5) ;
- ( UPDATE) - , 210 250 , .
_ _, , INSERT UPDATE . , _ (153 254) ? , ('', '', 5) __. : , '' ?; , '' ?; , 5 ?. , _-_ , , , .
, , . " ". , , . __. " " " - - ".
|
|
, - - . , - , . , , . - " ". -, UPDATE, , -, , , . , . DELETE, INSERT UPDATE .
5.4.4.
, , - () , , , . - , , .
, - , , . . ( ).
, , . , , .
6. SQL