Insert

INSERT

INSERT adds one or more rows to a table.

INSERT INTO table_name (column_name [, ...])
    VALUES ( value [, ...]) [, ...]     

table_name

Name of the table

column_name

This is required. Name of each column.

value

This is the value to insert for the respective column.

The values group can be repeated to perform bulk inserts.

INSERT INTO metrics (time, metric, value)
VALUES ('2020-04-27 12:11:00', 'cpu.1', 20.0),
       ('2020-04-27 12:11:00', 'cpu.2', 18.3),
       ('2020-04-27 12:11:00', 'cpu.3', 21.5),
       ('2020-04-27 12:11:00', 'cpu.4', 15.0)