(, ) . , .
: . , (, -). , .
- , , , .
, .. . . ( ), , , . , , , . , , . , . , .
, .
- . (, SQL) . , .
Data Manipulation Language (DML) ( () ) , , , .
DML : Procedural DMLs ; Declarative DMLs .
|
|
DML SQL, . DML IMS/DL1, CODASYL ( IDMS), .
DML ( ), . SQL insert (), update (), delete (). () .
DML . SQL, ANSI, .
SQL , , , , , :
- DDL ;
- DML ;
- DQL ;
- DCL ;
- ;
- .
(Data Definition Language, DDL) , , . DDL : CREATE TABLE, ALTER TABLE, DROP TABLE, CREATE INDEX, ALTER INDEX, DROP INDEX.
(Data Manipulation Language, DML) : INSERT, UPDATE, DELETE.
DQL , , SELECT. .
(Data Control Language, DCL) , . , , , . : GRANT, REVOKE.
; . , .
, : COMMIT, ROLLBACK, SAVEPOINT, SET TRANSACTION.
() , . .
, . , , .