DELETE statement is used to delete existing records in a table.
1DELETE FROM table_name
2WHERE condition;
INFO
WHERE condition is important for DELETE statement because it specifies which record(s) that should be deleted. If you omit the WHERE clause, all records in the table will be deleted!
Sample Database
| Id | FullName | Title | Department | Manager |
|---|---|---|---|---|
| 1 | Eric Brown | Software Engineer | IT | Frank Martin |
| 2 | Brandon Hart | DevOps Engineer | IT | Justin Martin |
| 3 | Connor Langdon | Software Engineer | IT | Lucas Scott |
| 4 | James Murray | Test Automation Engineer | IT | Frank Martin |
| 5 | Leonard Smith | Software Engineer | IT | Frank Roberts |
Examples / Outputs
1DELETE FROM Engineer
2WHERE Id = 2;
| Id | FullName | Title | Department | Manager |
|---|---|---|---|---|
| 1 | Eric Brown | Software Engineer | IT | Frank Martin |
| 3 | Connor Langdon | Software Engineer | IT | Lucas Scott |
| 4 | James Murray | Test Automation Engineer | IT | Frank Martin |
| 5 | Leonard Smith | Software Engineer | IT | Frank Roberts |
1-- it deletes all records in Engineer table
2DELETE FROM Engineer;
| Id | FullName | Title | Department | Manager |
|---|