Difference between revisions of "SQL:Data Manipulation Language"
Revision as of 00:06, 7 January 2015
|Table of contents|
The Data Manipulation Language (DML) is used to change, add and delete data in an existing table. The following SQL Commands are available:
By the end of this page you should be :
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!
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
- 12.2.5. INSERT Syntax (2010) In MySQL 5.0 Reference Manual. Oracle. Retrieved October 24, 2010 from http://dev.mysql.com/doc/refman/5.0/en/insert.html
- 12.2.11. UPDATE Syntax. (2010) In MySQL 5.0 Reference Manual. Oracle. Retrieved October 24, 2010 from http://dev.mysql.com/doc/refman/5.0/en/update.html
- 12.2.2. DELETE Syntax. (2010) In MySQL 5.0 Reference Manual. Oracle. Retrieved October 24, 2010 from http://dev.mysql.com/doc/refman/5.0/en/delete.html