Basic syntax and examples of the VALUES clause - Simple Log Service

The VALUES clause constructs temporary data rows that you can insert into a table for querying and analysis.

Syntax

VALUES(column_value01, column_value02...) table_name(column_name01,column_name02...)

Parameter descriptions

Parameter	Description
column_value	The value to insert into a column. It can be a constant, expression, or function.
table_name	The name of the table to insert data into.
column_name	The name of the column to insert data into.

Examples

The following example inserts data into the pv column of the access table.

Query statement

* |
SELECT
  pv
FROM  (
    VALUES
      (0),
      (1),
      (2),
      (3),
      (4),
      (5),
      (6),
      (7),
      (8),
      (9)
  ) AS access(pv)