Skip to content
On this page

DELETE

DELETE is used to remove rows from a table.

Syntax

sql
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:

sql
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:

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