DELETE #

DELETE is used to remove rows from a table.

Syntax #

DELETE FROM [db.]table WHERE expr

It removes rows from the table [db.]table that satisfies the expression expr after WHERE. The removed rows are marked immediately and can't be retrieved by all subsequent queries.

NOTE: GreptimeDB 0.1 only supports deleting rows that match the primary key and timestamp index. Later version will soon be able to delete rows by using the WHERE expressions.

Example #

For example, there is a table with the primary key host:

CREATE TABLE monitor ( host STRING, ts TIMESTAMP, cpu DOUBLE DEFAULT 0, memory DOUBLE, TIME INDEX (ts), PRIMARY KEY(host)) ;

To delete a row from it by primary key host and timestamp index ts:

DELETE FROM monitor WHERE host = 'host1' and ts = 1655276557000;