UPDATE (), DELETE () INSERT ().
UPDATE.
UPDATE :
UPDATE
SET =
[, = ]...
[WHERE ];
"", "", " = " SET ().
2 '':
UPDATE
SET = '', = ''
WHERE _ = 2;
, (. . , WHERE, , WHERE ), SET , - SET.
, .
UPDATE
SET = 2*
WHERE = '';
10 .
UPDATE
SET = 10
WHERE '' =
(SELECT
FROM
WHERE ._ = ._);
. , UPDATE . (, ): UPDATE - , , , UPDATE. UPDATE, , . , .
COMMIT ROLLBACK
.
- , SQL. COMMIT ROLLBACK.
- SQL , , , , - , . , :
- COMMIT (), ();
- ROLLBACK (), .
UPDATE
SET = ''
|
|
WHERE _ = 3;
COMMIT
DELETE.
DELETE :
DELETE
FROM
[WHERE ];
"", "".
:
DELETE
FROM
WHERE = '';
, - , ; UPDATE, DELETE, .
.
DELETE
FROM
WHERE = '';
- , . - ( DROP).
.
DELETE
FROM
WHERE '' =
(SELECT
FROM
WHERE ._ = ._);
INSERT.
INSERT :
INSERT
INTO [( [,]...)]
VALUES ( [,]...);
INSERT
INTO [( [,]...)]
;
"" , , i- i- . ""; , , , , "". i- i- . .