:
( - 34, - , - , - , - 150)
.
INSERT
INTO (, , , , )
VALUES (34, '', '', '', 150);
34, .
INSERT , . :
INSERT
INTO (, , , , )
VALUES ('', '', '', 34, 150);
(, 5 ) :
INSERT
INTO
VALUES (34, '', '', '', 150, 5);
, , -, , .
, .. (..2.4 - [2]). , , "" , 34. , ?
, , ( = 1) (15 ) ( = 10),
INSERT
INTO (, , )
VALUES (1, 10, 15);
DELETE INSERT . , , = 1 - = 10. : . , , [2], -, "" - , - .
4.3.2.
_, , . ( - .)
, , CREATE TABLE (..5.2)
CREATE TABLE _
( CHAR (10),
CHAR (60),
_ INTEGER,
_ REAL);
INSERT :
INSERT
INTO _
SELECT , ,
INT(SUM(((+)*4.1+*9.3) * /1000)),
(SUM(/_*/1000) + MIN(/100))
FROM , _, , ,
|
|
WHERE . = .
AND . = .
AND . = .
AND . = _.
AND NOT IN
(SELECT
FROM
WHERE IN
(SELECT
FROM
WHERE _ = 0))
GROUP BY ,
ORDER BY , 3;
SELECT , (. .3.6), , _. (, -,...), .. , .. (, , ). , . , -, DROP TABLE _ , .
4.3.3. INSERT...SELECT
.3.2.3 - , . , 34 , , :
CREATE TABLE
( CHAR (8),
CHAR (60),
CHAR (560));
INSERT
INTO
SELECT , ,
FROM , , _
WHERE . = .
AND . = _.;
( 34, ).
, , . ( ) . :
INSERT
INTO
SELECT , ,
FROM , , _
WHERE . = .
AND . = _.;
INSERT
INTO
SELECT , , "???"
FROM , _
WHERE . = _.
AND NOT IN
(SELECT
FROM );
... | ||
,... | ||
... | ||
... | ||
, ... | ||
??? |
33 INSERT (), . INSERT , .
, INSERT...SELECT. INSERT...SELECT, UNION, SELECT INSERT:
|
|
INSERT
INTO
SELECT , ,
FROM , , _
WHERE . = .
AND . = _.
UNION
SELECT , , "???"
FROM , _
WHERE . = _.
AND NOT IN
(SELECT
FROM );
4.4. UPDATE