DELETE
FROM
WHERE IN
(SELECT
FROM
WHERE = '');
,
DELETE FROM TOVR,
TRUNCATE TABLE TOVAR;
INSERT
INSERT :
INSERT
INTO _ [( [,]...)]
VALUES ({ | } [,{ | }]...);
INSERT
INTO _ [( [,]...)]
;
, VALUES (), i- i- (, , NULL-). VALUES , INTO . , ( ) INSERT .
, .. SELECT , . i- (i- SELECT) i- . INTO.
.
.
INSERT
INTO (, , , , )
VALUES (34, '', '', '', 150);
:
INSERT
INTO TOVAR
SELECT *
FROM TOVAR2
WHERE CODE NOT IN
(SELECT CODE
FROM TOVAR)
48. CASE-.
ToadDateModeler
c. 4, 9,13
UPDATE
UPDATE . :
UPDATE _SET = [, = ]...[WHERE ]| | |
, .
UPDATE _SET = [, = ]...FROM _ [], _ ] [,_ []]...[WHERE ]UPDATE [ -] SET [ -]. = []*"1,5"
WHERE ((([ -].idk)=5));
UPDATE
SET = '', = (+30), = NULL
WHERE = 5;
UPDATE
SET = * 3
WHERE <> 17;
49
UPDATE SET = 0, _ = 0WHERE IN (SELECT FROM WHERE IN ('', ''));
|
|
, , . ( ),
CREATE TABLE _ ( _ [NOT NULL]
[, _ [NOT NULL]]...);
[, ]
[, ];
CREATE TABLE STUDENT (SNUM SMALLINT NOT NULL UNIQUE,
NAME CHAR(20) NOT NULL,
FNAME CHAR(20),
DOB DATE,
SGROUP CHAR,
PRIMARY KEY(SNUM),
FOREIGN KEY (SGROUP)
REFERENCE GROUP); -
- PRIMARY KEY(SNUM, LNAME),
DROP TABLE _ -
ALTER TABLE _
2 : add, modify
modify
ALTER TABLE STUDENT MODIFY (FNAME CHAR(50));
ADD
ALTER TABLE STUDENT ADD (PASP CHAR(50));