Difference between revisions of "Delete Queries"
(Created page with "Used for deleting rows from a table. DELETE FROM table WHERE column1=value1; DELETE FROM table WHERE column1=value1 AND column2=value2; * Not specifying which records to d...") |
|||
| Line 5: | Line 5: | ||
* Not specifying which records to delete will result in every record being deleted | * Not specifying which records to delete will result in every record being deleted | ||
| − | * The same can be achieved with 'DELETED * FROM table' | + | :*The same can be achieved with 'DELETED * FROM table' |
* This process cannot be undone | * This process cannot be undone | ||
* Not to be confused with DROP, for deleting columns and tables. | * Not to be confused with DROP, for deleting columns and tables. | ||
Revision as of 16:02, 21 December 2016
Used for deleting rows from a table.
DELETE FROM table WHERE column1=value1; 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.
