SQL , . . SQL- 1 . 2 . 3 /. 4 . 5 . : 1 - ; 2 - ; 3 - ; 4 - Microsoft ( ODBC ADO) IBM; 5 - ; 6- , ; 7 - ; 8- ; 9 - ; 10 - , ; 11 - ; 12 - /; 13 - - ; 14 - Internet; 15 - Java ( JDBC).
SQL
SQL , . , INSERT (), DELETE (), COMMIT (), CREATE TABLE ( ). . , , , , .. . , , , . , , , WHERE (), FROM (), INTO (), HAVING (). ; . , 1 18 , . SQL.
SQL
SQL , : () (CHARACTER ( CHAR); CHARACTER VARYING ( VARCHAR); CHARACTER LARGE OBJECT ( CLOB)). : - (INTEGER; SMALLINT; BIGINT; NUMERIC; DECIMAL)- (REAL; DOUBLE PRECISION; FLOAT). () BOOLEAN; - (DATE; TIME WITHOUT TIME ZONE; TIME WITH TIME ZONE; TIMESTAMP WITHOUT TIME ZONE; TIMESTAMP WITH TIME ZONE). . (ROW (); ARRAY (); MULTISET ()). - , .
SQL
CREATE DATABASE. db_name - , . CHARACTER SET, COLLATE - . , SHOW CREATE DATABASE. . (SELECT) ( ), (DELETE) , (INSERT) , (UPDATE) . : , , . : Update. , . Where , . Set , .
|
|
|
