mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 09:49:40 +00:00
7 lines
247 B
Plaintext
7 lines
247 B
Plaintext
|
|
CREATE TABLE t600(a PRIMARY KEY, b) WITHOUT rowid;
|
|
CREATE INDEX t600b ON t600(b);
|
|
INSERT INTO t600 VALUES('state','screen'),('exact','dolphin'),('green','mercury');
|
|
SELECT a, b, '|' FROM t600 WHERE a=='state' OR b='mercury' ORDER BY +a;
|
|
|