DELETE FROM
Warning
Supported only for row-oriented tables. Support for column-oriented tables is currently under development.
Instead of using DELETE FROM
to delete data from colum-oriented tables, you can use the mechanism of deleting rows by time — TTL. TTL can be set when creating the table via CREATE TABLE
or modified later via ALTER TABLE
.
Deletes rows that match the WHERE
clause, from the table.
Example
DELETE FROM my_table
WHERE Key1 == 1 AND Key2 >= "One";
DELETE FROM ... ON
Deletes rows based on the results of a subquery. The set of columns returned by the subquery must be a subset of the table's columns being updated, and all columns of the table's primary key must be present in the returned columns. The data types of the columns returned by the subquery must match the data types of the corresponding columns in the table.
The primary key value is used to search for rows to be deleted from the table. The presence of other (non-key) columns of the table in the output of the subquery does not affect the results of the deletion operation.
Example
$to_delete = (
SELECT Key, SubKey FROM my_table WHERE Value = "ToDelete" LIMIT 100
);
DELETE FROM my_table ON
SELECT * FROM $to_delete;