DELETE (), INSERT () UPDATE (). SELECT , . . , 5, , "" .
DELETE
DELETE
FROM |
[WHERE ];
( WHERE ) , WHERE .
INSERT :
INSERT
INTO { | } [( [,]...)]
VALUES ({ | } [,{ | }]...);
INSERT
INTO { | } [( [,]...)]
;
, VALUES (), i- i- (, , NULL-). VALUES , INTO . , ( ) INSERT .
, .. SELECT , . i- (i- SELECT) i- . INTO.
UPDATE . :
UPDATE ( | }
SET = [, = ]...
[WHERE ]
-
| | |
, .. , , .
WHERE . WHERE , .
, . . :
UPDATE { | }
SET = [, = ]...
FROM { | } [],
{ | } []
[,{ | } []]...
[WHERE ]
FROM , . , , WHERE (..3.2.3), , , .
, SET, , ().
4.2. DELETE