: DELETE, INSERT ( ) UPDATE. .
.
INSERT :
INSERT INTO _ [(< >) ] VALUES (< >). , . , BOOKS
INSERT INTO BOOKS (ISBN,TITLE,AUTOR,COAUTOR,YEARIZD,PAGES) VALUES ("5-88782-290-2", " IBM PC. ", " . ","",2000,816), , COAUTOR, VALUES. , , . NULL.
, , , :
INSERT INTO BOOKS VALUES ("5-88782-290-2", " IBM PC. ", " .","",2000,816).
, , , . , :
INSERT INTO BOOKS (ISBN,TITLE,AUTOR,YEARIZD,PAGES) VALUES ("5-88782-290-2", " IBM PC. ", " .",2000,816)COAUTOR NULL.
? , . (NOT NULL) , INSERT . , , . , , .
. , . , , EXEMPLAR :
|
|
, 1872 344, , , ( GetDate()), , DateAdd (), "". 14 .
, . , : , , . :
INSERT INTO READER (NAME_READER, ADRESS, HOOM_PHONE, BIRTH_DAY)SELECT (NAME_STUDENT, ADRESS, HOOM_PHONE, BIRTH_DAY)FROM STUDENT, . , , , .
, .
DELETE :
DELETE FROM _ [WHERE _], , , . , , .
, , R1
DELETE FROM R1WHERE , SELECT. , . , . ., :
DELETE FROM R2WHERE = ' ..'WHERE . , , , . , , , . - R1 2 , , , , , . SQL , .
DELETE FROM R2 WHERE R2. IN (SELECT R1. FROM R1WHERE = 2 OR IS NULL GROUP BY R1. HAVING COUNT(*) >= 2DELETE, , , , , , , .
|
|
UPDATE , , , . , , , . . " " . R1. :
UPDATE _SET _ = _ [WHERE _]WHERE , DELETE. , DELETE, , . , .
UPDATE R1SET R1. = 4WHERE R1. = " .." AND R1. = " "
? . , , , , . R4 :
R4 = <, >R4 | |
:
UPDATE R4SET R4.Kypc = R4.Kypc + 1:
, , . , , , . . R1 . R5 :
R5 | ||
. . | <Null> | |
. . | <Null> | |
. . | <Null> | |
. . | <Null> | |
. . | <Null> | |
. . | <Null> | |
. . | <Null> | |
. . | <Null> |
, + 50% , 25%, , 100% . 0%. .
:
UPDATE R5SET R5. = 50% WHERE R5. IN(SELECT R1.FROM R1WHERE R1. = 5GROUP BY R1.HAVING COUNT(*) =3)25%:
UPDATE R5SET R5. = 25% WHERE R5. IN (SELECT R1. FROM R1WHERE R1. NOT IN (SELECT A. FROM R1 AWHERE A. <=3 OR A. IS NULL) GROUP BY R1. HAVING COUNT(*)>=2):
UPDATE R5SET R5. = 0%WHERE R5. IN (SELECT R1. FROM R1WHERE R1. >=4 AND R1. NOT IN (SELECT A. FROM R1 AWHERE A. <= 3 OR A. IS NULL)):
UPDATE R5SET R5. = 100% WHERE R5. IN(SELECT R1. FROM R1WHERE R1. <= 2 OR R1. IS NULL)