.


:




:

































 

 

 

 





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





:


: 2016-11-02; !; : 366 |


:

:

.
==> ...

1436 - | 1412 -


© 2015-2024 lektsii.org - -

: 0.008 .