SQL , . , INSERT (), DELETE (), COMMIT (), CREATE TABLE ( ).
. , , , , ..
. , , , . , , , WHERE (), FROM (), INTO (), HAVING (). ; .
, 1 18 , . SQL.
SQL , .
1. SQL
CHARACTER(n) CHAR(n) | n . 255 |
DATE, TIME, TIMESTAMP | , |
NUMERIC[(n,m)] | , n , m |
DECIMAL[(n,m)] DEC [(n,m)] | , n , m |
INTEGER INT | 2147483648 2147483647 |
SMALLINT | 32768 32767 |
FLOAT[(n)] | , . n , |
REAL | -3.40282338 3.40382338 |
DOUBLE PRECISION | -1.79769313486232308 1.797....308 |
SQL
SQL, SQL:2003, SQL:1999 , . . , SQL, (entry), (intermediate) (full) . , .
SQL .
, :
3. %
1,2 3 2 4-7. , .
|
|
.. :
% | ||
% | |||||
. | 02.02.2009 | ||||
. | 05.01.2009 | ||||
. | 10.01.2009 | ||||
. | 02.02.2009 | ||||
. | 01.03.2009 | ||||
. | 02.02.2009 | ||||
. | 02.02.2009 | ||||
. | 05.01.2009 | ||||
. | 05.01.2009 | ||||
. | 04.03.2009 | ||||
. | 02.02.2009 | ||||
. | 02.02.2009 |
, , . [] [ ] .
, , ( ).
CREATE TABLE
: CREATE TABLE < >
({< > < >[<>] [< >][< >] },...)
,
*CREATE TABLE ([ ] CHAR(30), CHAR(5), [ %] INT))
, : , , %. 30 5 , % .
DROP TABLE
: DROP TABLE < >
, DROP TABLE
.
ALTER TABLE
: ALTER TABLE < >
({< > < >[<>] [< >][< >] },...)
, ALTER TABLE ( CHAR(30))
, 30 .
CREATE VIEW - , , .. .
: CREATE VIEW < > AS <>
[ WITH CHECK OPTION ]
, , .
* INSERT -
: INSERT INTO < > [{< 1>},...]
VALUES ({<>},...)
,
INSERT INTO VALUES ( , "", 3)
, , "", 3.
|
|
DELETE
: DELETE FROM < > [ WHERE <>]
,
DELETE FROM WHERE [ ] =
, [ ] .
* UPDATE
UPDATE < > SET
{< >=<>},... [ WHERE <>]
UPDATE , SET , . WHERE . , . , .
,
UPDATE SET [ %] = 0.9*[ %];
10% ( [ %] 10%).
UPDATE SET [ %] = 1.1*[ %]
WHERE = є;
10%.
4 ( WHERE)
, [% ] %- , , , .
UPDATE , SET [% ] = [ %]/100*[ ]/12
WHERE .=.[ ];
% | |||||
. | 02.02.2009 | ||||
. | 05.01.2009 | ||||
. | 10.01.2009 | ||||
. | 02.02.2009 | ||||
. | 01.03.2009 | ||||
. | 02.02.2009 | ||||
. | 02.02.2009 | ||||
. | 05.01.2009 | ||||
. | 05.01.2009 | 83,33334 | |||
. | 04.03.2009 | ||||
. | 02.02.2009 | 2,5 | |||
. | 02.02.2009 |
5
1. SELECT
2.
3. WHERE
4. . GROUP BY HAVING
5.
6.