SQL :
(Data Definition Language, DDL)
CREATE ( , , , . .)
ALTER
DROP
(Data Manipulation Language, DML)
SELECT ,
INSERT
UPDATE
DELETE
(Data Control Language, DCL)
GRANT ()
REVOKE
DENY ,
(Transaction Control Language, TCL)
COMMIT
ROLLBACK ,
SAVEPOINT
ANSI/ISO SQL92:
1)
2)
3)
3.1 CHAR VARCHAR
3.2 BLOB TEXT
3.3 ENUM
ENUM () , , . () NULL ; ENUM, , . , 0. ENUM NULL, NULL NULL. ENUM NOT NULL, . |
3.4 SET
SET , , , . SET . , . , SET(, ) NOT NULL : , , , SET 64 . |