# Delete Queries

Jump to: navigation, search

Used for deleting rows from a table. The where section should give the criteria for deleting records, for example the specific ID for the record could be used. Alternatively the criteria could be more complex and use multiple criteria.

   DELETE FROM table WHERE column1=value1;


or:

   DELETE FROM table WHERE column1=value1 AND column2=value2;


## Notes

• 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.

### Basic Quiz

All these questions will use this table called Employees:

1. which is the command to remove a record from a table:

 Drop Record → Incorrect Remove Record → Incorrect Delete From → Correct Delete Record' → Incorrect

2. which of the following will successfully delete the record for 'Wonder Woman':

 Delete From Employees Where 'First Name' = 'Wonder' , 'Last Name' = 'Woman' → Incorrect Delete From Employees Where 'Name' = 'Wonder Woman' → Incorrect Delete From Employees Where 'Last Name' = 'Woman' → Incorrect Delete From Employees Where 'First Name' = 'Wonder' And 'Last Name' = 'Woman' → Correct

Your score is 0 / 0