mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 07:29:41 +00:00
26 lines
552 B
Plaintext
26 lines
552 B
Plaintext
|
|
CREATE TABLE t1(a, b, c);
|
|
INSERT INTO t1 VALUES(1, 2, 3);
|
|
INSERT INTO t1 VALUES(4, 5, 6);
|
|
ALTER TABLE t1 ADD COLUMN d DEFAULT 'string';
|
|
INSERT INTO t1 VALUES(7, 8, 9, 'text');
|
|
|
|
|
|
SELECT * FROM t1 ORDER BY b;
|
|
|
|
|
|
DROP TABLE IF EXISTS t1;
|
|
CREATE TABLE t1(a, b);
|
|
CREATE TABLE t2(c, d, PRIMARY KEY(c)) WITHOUT ROWID;
|
|
|
|
INSERT INTO t1 VALUES(1, 2);
|
|
INSERT INTO t1 VALUES(2, 3);
|
|
INSERT INTO t1 VALUES(3, 4);
|
|
|
|
INSERT INTO t2 VALUES(1, 'one');
|
|
INSERT INTO t2 VALUES(3, 'three');
|
|
|
|
|
|
SELECT * FROM t1 LEFT JOIN t2 ON (a=c) ORDER BY b;
|
|
|