Blog

When you need to delete one, some or all of the records in a table, you can use the SQL DELETE command.

Syntax:

DELETE FROM table_name

Delete all records in a table.

DELETE FROM table_name
WHERE conditions

Delete records in one table that match the WHERE condition.

Note: You need to be careful when using the DELETE command! As it is not possible to undo this operation!