DELETE FROM

• DELETE FROM … ON

Note

Example

Used to delete the data, if the table has already been changed within the same transaction.

$to_delete = (
SELECT * FROM my_table;
DELETE FROM my_table ON 
SELECT * FROM $to_delete;