INSERT INTO
Warning
Supported only for row-oriented tables. Support for column-oriented tables is currently under development.
Available methods for loading data into columnar tables:
Adds rows to the table. If you try to insert a row into a table with an existing primary key value, the operation fails with the PRECONDITION_FAILED
error code and the Operation aborted due to constraint violation: insert_pk
message returned.
INSERT INTO
lets you perform the following operations:
-
Adding constant values using
VALUES
.INSERT INTO my_table (Key1, Key2, Value1, Value2) VALUES (345987,'ydb', 'Pied piper', 1414); COMMIT;
INSERT INTO my_table (key, value) VALUES ("foo", 1), ("bar", 2);
-
Saving the
SELECT
result.INSERT INTO my_table SELECT Key AS Key1, "Empty" AS Key2, Value AS Value1 FROM my_table1;