SQL Data Manipulation Language(DML)

SQL (Structured Query Language) is a syntax for executing queries . But the SQL language also includes a syntax to update,insert and delete records.

These query and update commands together  form the Data Manipulation Language (DML) part of SQL:

·SELECT: extracts data from a database table

·UPDATE: updates data in a database  table

·DELETE :deletes data from a database table

Transaction Control Commands:

Transaction Control Commands manage changes made by Data Manipulation Language commands. These commands are listed in the following table.

Command	Purpose
COMMIT	To make permanent the changed made by statements issued at the beginning of transaction
ROLLBACK	To undo all changes since the beginning of a transaction or since a savepoint.
SAVEPOINT	To establish a point back to which you ma y roll.
SET TRANSACTION	To establish properties for the current transaction.