SQL ​

INSERT Statement ​

Let's insert some testing data to the monitor table which we created before. You can use the INSERT INTO SQL statements:

INSERT INTO monitor
VALUES
    ("127.0.0.1", 1667446797450, 0.1, 0.4),
    ("127.0.0.2", 1667446798450, 0.2, 0.3),
    ("127.0.0.1", 1667446798450, 0.5, 0.2);

Query OK, 3 rows affected (0.01 sec)

Through the above statement, we have inserted three rows into the monitor table.

For more information about the INSERT statement, please refer to INSERT.

HTTP API ​

Using POST method to insert data:

curl -X POST \
  -H 'authorization: Basic {{authorization if exists}}' \
  -H 'Content-Type: application/x-www-form-urlencoded' \
  -d 'sql=INSERT INTO monitor VALUES ("127.0.0.1", 1667446797450, 0.1, 0.4), ("127.0.0.2", 1667446798450, 0.2, 0.3), ("127.0.0.1", 1667446798450, 0.5, 0.2)' \
http://localhost:4000/v1/sql?db=public

The result is shown below:

{"code":0,"output":[{"affectedrows":3}],"execution_time_ms":0}

For more information about SQL HTTP request, please refer to API document.

DELETE Statement ​

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

DELETE FROM monitor WHERE host='127.0.0.2' and ts=1667446798450;

Query OK, 1 row affected (0.00 sec)

For more information about the DELETE statement, please refer to the SQL DELETE.

HTTP API ​

Using POST method to delete data:

curl -X POST \
  -H 'authorization: Basic {{authorization if exists}}' \
  -H 'Content-Type: application/x-www-form-urlencoded' \
  -d "sql=DELETE FROM monitor WHERE host = '127.0.0.2' and ts = 1667446798450" \
http://localhost:4000/v1/sql?db=public

The result is shown below:

{"code":0,"output":[{"affectedrows":1}],"execution_time_ms":1}

For more information about SQL HTTP request, please refer to API document.