SQL:Data Manipulation Language

Introduction
The Data Manipulation Language (DML) is used to change, add and delete data in an existing table. The following SQL Commands are available:
 * INSERT
 * UPDATE
 * DELETE

DDL Example
In the heights database the following DML commands were sent to MySQL:

.. and if I wanted to create a backup of the People table I could use


 * WARNING** the DELETE here permenantly removes all records from the Bak table.. be very careful you have entered the correct table!

Backus-Naur Form
For the complete format refer to [http://dev.mysql.com/doc/refman/5.0/en/insert.html 12.2.5. INSERT Syntax (2010) ]

Examples
If you want to insert into all fields (and there is an autonumber one), and don't want to specify all field names use Null (or \N )

Note you can also use \N for null

Backus-Naur Form
For the complete format refer to [http://dev.mysql.com/doc/refman/5.0/en/update.html 12.2.11. UPDATE Syntax. (2010) ]

Backus-Naur Form
For the complete format refer to [http://dev.mysql.com/doc/refman/5.0/en/delete.html 12.2.2. DELETE Syntax. (2010) ]