Difference between revisions of "Delete Queries"
| Line 2: | Line 2: | ||
<syntaxhighlight lang=sql> | <syntaxhighlight lang=sql> | ||
| − | DELETE FROM table WHERE column1=value1; | + | DELETE FROM table WHERE column1=value1; |
</syntaxhighlight> | </syntaxhighlight> | ||
| Line 8: | Line 8: | ||
<syntaxhighlight lang=sql> | <syntaxhighlight lang=sql> | ||
| − | DELETE FROM table WHERE column1=value1 AND column2=value2; | + | DELETE FROM table WHERE column1=value1 AND column2=value2; |
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 22:32, 21 December 2016
Used for deleting rows from a table.
DELETE FROM table WHERE column1=value1;
or:
DELETE FROM table WHERE column1=value1 AND column2=value2;
- Not specifying which records to delete will result in every record being deleted
- The same can be achieved with 'DELETED * FROM table'
- This process cannot be undone
- Not to be confused with DROP, for deleting columns and tables.
