Delete Queries

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