Deletes rows that match the
WHERE clause, from the table.
The changes of the table state can't be tracked within a single transaction. If the table has already been changed, use
DELETE ON to delete the data within the same transaction.
DELETE FROM my_table WHERE Key1 == 1 AND Key2 >= "One"; COMMIT;
DELETE FROM ... ON
Used to delete the data, if the table has already been changed within the same transaction.
$to_delete = ( SELECT Key, SubKey FROM my_table WHERE Value = "ToDelete" ); SELECT * FROM my_table; DELETE FROM my_table ON SELECT * FROM $to_delete; COMMIT;