MySQL DELETE Statement
DELETE statement is used to delete a record (or records) in a database table. When using the
DELETE statement, you specify the table name and the record/s to be deleted.
The above statement deletes record
204 from the
actor table of the
If we run a
SELECT statement before and after the
DELETE statement, here's the result.
Delete All Records
You can delete all records from a table, simply by omitting the
The following statement will delete all records from the
The examples on this page use the Sakila sample database.