DELETE FROM mytable WHERE id=123;
DELETE is a DML statement that removes rows from a table. The
DELETE statement deletes rows from tbl_name and returns the number of deleted rows. To check the number of deleted rows, call the
The conditions in the optional
WHERE clause identify which rows to delete. With no
WHERE clause, all rows are deleted.