13 lines
310 B
Text
13 lines
310 B
Text
statement ok
|
|
CREATE TABLE kanto.myschema.mytable (mycolumn BIGINT NOT NULL, PRIMARY KEY(mycolumn));
|
|
|
|
statement ok
|
|
INSERT INTO kanto.myschema.mytable (mycolumn) VALUES (42), (13);
|
|
|
|
statement ok
|
|
DELETE FROM kanto.myschema.mytable WHERE mycolumn=42;
|
|
|
|
query I rowsort
|
|
SELECT * FROM kanto.myschema.mytable;
|
|
----
|
|
13
|