, SQL (, , . .) , . , SQL : DDL DML. SQL . 10.
:
Ø , , (, CREATE , DELETE . .);
Ø , , , , . , , WHERE (), FROM (), INTO (), HAVING ();
Ø " [] " ;
Ø "|", , , , ;
Ø "{}" , ;
Ø , , , .
10
SQL
| DDL | CREATE TABLE | |
| DROP TABLE | ||
| ALTER TABLE | ||
| CREATE INDEX | ||
| DROP INDEX | ||
| CREATE VIEW | ||
| DROP VIEW | ||
| GRAND | ||
| REVOKE | ||
| CREATE SCHEMA | ||
| DROP SCHEMA | ||
| DML | SELECT | |
| UPDATE | ||
| INSERT | ||
| DELETE |
SQL.
:
CREATE TABLE < >
(< > < > [NOT NULL]
[,< > < > [NOT NULL]]...)
, , . ( ) ANSI/ISO 1 18 , ( -).
, . SQL : , , , . , SQL.
|
|
|
. NOT NULL ( ) , () .
3.28.
ORDERS . :
CREATE TABLE ORDERS (ORDER_NUM INTEGER NOT NULL, CUST_NUM INTEGER NOT NULL, PROD_ID INTEGER NOT NULL, QTY INTEGER NOT NULL, DATE_ORDER DATE NOT NULL)
INTEGER , DATE , .
. :
ALTER TABLE < >
{ADD|ALTER|DROP} < > [< >]
[NOT NULL]
[,{ADD|ALTER|DROP} < > [< >]
[NOT NULL],..]
(ADD), (ALTER) (DROP) .
3.29.
CUST CUST_PHN, . :
ALTER TABLE CUST ADD CUST_PHN CHAR (10)
3.30.
PROD STORE. ( ).
