DELETE FROM

• DELETE FROM … ON

Deletes rows that match the WHERE clause, from the table.

Note

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.

Example

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.

Example

$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;