DELETE FROM table_name WHERE where_definition
Returns records affected.
If one does a delete without a WHERE clause then the table is
recreated, which is much faster than doing a delete for each row. In
these cases, the command returns zero as affected records. MySQL
can't return the number of deleted row because the recreate is done without
opening the data files to make sure that one can recreate the table as
long as the table definition file table_name.frm is valid.
Go to the first, previous, next, last section, table of contents.