Delete (SQL)

In the database structured query language (SQL), the DELETE statement is used to remove one or more rows from a table. A subset may be defined for deletion using a condition, otherwise all records are removed. Some database management systems (DBMSs), like MySQL, allow deletion of rows from multiple tables with one DELETE statement (this is sometimes called multi-table DELETE).

It is not possible to delete individual values using DELETE, instead UPDATE should be used to set the value to NULL. Backups should always be created before using DELETE.

This page is issued from Wikipedia. The text is available under Creative Commons Attribution-Share Alike 4.0 unless otherwise noted. Additional terms may apply for the media files.