SQL . ., . . . . ., ., , . ., . . (, . ., ).. SQL . . ., . . . .
SQL . . . , . . , . . , . SQL-. , SQL.
SQL: ; . , ; . SQL ; . SQL ; . SQL , ; . SQL - . SQL : ( ) ( ). SQL . SQL ( SQL). SQL , :
, ;
;
;
;
;
;
;
/;
( , );
- .
53. SQL
SQL
CREATE TABLE
INSERT
DELETE
UPDATE
SELECT
CREATE VIEW *
GRANT
REVOKE
"
COMMIT
ROLLBACK
SQL
DECLARE *
|
|
OPEN
FETCH
CLOSE
SQL . , , . , CREATE (), INSERT..(), COMMIT (). . , , , . . , WHERE (), FROM (), INTO (), _(). , . . ; 1 18 , .
54. SQL. SQL
SQL
R() RR()
INTEGER INT
SMALLINT
NUMERIC(, ) DECIMAL(, ) D(, )
FLOAT ()
REAL
DOUBLE PRECISION
.
SQL . ( (+) ). , 21, -375.18, 62.3. , . , 1.57, 2.5-6, -0.78324 ( " "). . , "", "New York".SQL (NULL). SQL , . . , , , . : '. + (), - (), * (), / (); : = (), > (), < (), >= ( ), <= ( ), <> ( ); : AND ( ""), OR ( ""), NOT (""); :IN. , ; BETWEEN. , ; LIKE.
. : %
(). ; _ (). ; IS NULL. NULL-. . , * (__ + - ).
55 - SQL: ; . /
SQL - , . SQL , , . ; , . , SQL- ( , ), , .SQL , , , .
|
|
SQL ( ) .
. SQL - (.
, .
, , .
CREATE TABLE ( INT, CHAR(15), INT, CHAR(3))
DROP TABLE
ALTER TABLE ( CHAR(10))
CREATE VIEW 1 AS SELECT *FROM WHERE = "-1"
, , .
INSERT INTO VALUES (980101, " . .", 1980, "")
DELETE FROM WHERE =980201
UPDATE SET = " . ." WHERE =980201
SELECT.
SELECT * FROM WHERE =" . ." OR =" . ."