SQL DELETE Statement

The DELETE statement is used to delete specific records/rows in a table


The DELETE Syntax
DELETE FROM table_name
WHERE some_column = some_value


The TRUNCATE statement is used to delete all records/rows in table


The TRUNCATE Systax
TRUNCATE TABLE table_name