16 lines
270 B
Text
16 lines
270 B
Text
statement ok
|
|
CREATE TABLE myschema.mytable (mycolumn BIGINT NOT NULL, PRIMARY KEY(mycolumn));
|
|
|
|
statement ok
|
|
BEGIN WORK;
|
|
|
|
statement ok
|
|
INSERT INTO kanto.myschema.mytable (mycolumn) VALUES (42);
|
|
|
|
statement ok
|
|
COMMIT;
|
|
|
|
query I
|
|
SELECT * from kanto.myschema.mytable;
|
|
----
|
|
42
|