Delete records from MySQL table
Question:How to delete records from MySQL table?
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.
Reference:The delete statement reference
Share "How to delete records from MySQL table?"
Tags:delete record from table, delete record mysql, delete all records
Technical term:Delete records from MySQL table