The delete statement is used to delete data from a table. Be careful when using this command, it is easy to delete more data than intended.
Syntax:
DELETE FROM table_name [WHERE condition];
If the where clause is omitted, all rows are deleted from the table. Depending on the use of the DELETE statement's WHERE clause, SQL can do the following:
Delete single rows
Delete multiple rows
Delete all rows
Delete no rows
