SQL , .
, SQL , :
;
;
.
, Access SQL SQL.
SQL
SQL . ( ) . .
:
;
;
, .
, . , , . -, .
, , ( ), . . 3.1.
3.1.
, SQL -
| ( ) | , ( ), . |
[ ] *( ) | , , , . |
< > ( ) | , , , |
{ } ( ) | , , , , , , . |
( ) | . |
:= ( ) | . |
, Access CREATE TABLE , . NOT NULL, .
:
CREATE TABLE (_1 [()]
[NOT NULL] [_1] [, _2 [()]
[NOT NULL] [_2] [,...]] [, CONSTRAINT [,...]])
CREATE TABLE:,. .3.2.
3.2.
CREATE TABLE
() | |
, . | |
_1, _2 | , . . |
. | |
( ). | |
_1, _2 | CONSTRAINT, . |
CONSTRAINT, |
.
|
|
- , SQL. . , ( ). , SQL , , , . .
:
- 䳺, 䳿, , -select, create table;
- , , where. . ;
- , order by.
() - , ;
. 䳿 , .
, SELECT. (Microsoft Jet) .
SELECT:
SELECT [] { * | .* | [.]_1
[AS _2] [, [2.]_2 [AS _2] [,...]]}
FROM [,...] [IN ]
[WHERE... ]
[GROUP BY... ]
[HAVING... ]
[ORDER BY... ]
[WITH OWNERACCESS OPTION]
SELECT
, . : ALL, DISTINCT, DISTINCTROW TOP. , ALL ( ). | |
* | , ( ). |
, . | |
_1, _2 | , . , . |
_1, _2 | , . |
, , . | |
, . , , , . |
SELECT .
̳ SELECT:
SELECT FROM .
SELECT .
, FROM, , . (). , "³" "" "". SQL "³" "" "" "":
|
|
SELECT .³, .
FROM INNER JOIN
WHERE .³ = .³;
, , , AS.
""
SELECT [ ]
AS FROM ;
AS , :
SELECT COUNT()
AS FROM ;
3.3. SQL- ( 䳿 )
SQL- :
1. ;
2. .
, , 䳿 . 䳿 , , SQL-.
:
;
- , , , SQL-;
SQL, , ;
( ) :
a) , ;
b) ;
c) ;
d) , ;
e) , ;
f) , ;
g) ;
h) ( );
i) SQL- .
, ., , , .
SQL
, SQL- . , SQL- , , :
;
.
. , .
SQL , . . 3.3.
3.3.
SQL
/ | SQL- | |||||||
DDL- (Data Definition Language) | ||||||||
1.1 1.2. 1.3. | 1. | |||||||
CREATE DATEBASE DROP DATEBASE | ||||||||
2. | ||||||||
CREATE TABLE ALTER TABLE RENAME TABLE DROP TABLE | C | , . | ||||||
3. | ||||||||
CREATE INDEX DROP INDEX | ||||||||
2. DML- -Data Manipulation Language (ij , .) | ||||||||
2.1. | ||||||||
SELECT | SELECT. , | |||||||
2.2. | ||||||||
INSERT REPLACE LOAD DATA INFILE | ³ . | |||||||
2.3. | ||||||||
INSERT REPLACE | ||||||||
2.4. | ||||||||
DELETE FROM | ||||||||
3. DCL- -Data Control Language | ||||||||
3.1. | ᒺ | |||||||
GRANT | . | |||||||
REVOKE | ³ | |||||||
3.2. | ( ) | |||||||
COMMIT SAVEPOINT ROLLBACK | Գ , . , | , . ij , . , SVEPOINT COMMIT ROLLBACK | ||||||
|
|