mirror of
https://github.com/tursodatabase/libsql.git
synced 2025-07-14 18:25:18 +00:00
36 lines
804 B
Plaintext
36 lines
804 B
Plaintext
|
|
CREATE TABLE t1(a INTEGER PRIMARY KEY, t TEXT);
|
|
INSERT INTO t1 VALUES(-1, $dots);
|
|
INSERT INTO t1 VALUES(-2, $dots);
|
|
INSERT INTO t1 VALUES(-3, $dots);
|
|
INSERT INTO t1 VALUES(-4, $dots);
|
|
INSERT INTO t1 VALUES(-5, $dots);
|
|
INSERT INTO t1 VALUES(-6, $dots);
|
|
|
|
|
|
CREATE TABLE t2(a TEXT, b INTEGER PRIMARY KEY);
|
|
INSERT INTO t2 VALUES($dots, 43);
|
|
INSERT INTO t2 VALUES($dots, 44);
|
|
INSERT INTO t2 VALUES($dots, 45);
|
|
|
|
|
|
CREATE TABLE t3(i INTEGER PRIMARY KEY, j TEXT, k TEXT);
|
|
INSERT INTO t3 VALUES(1, $dots, $dots);
|
|
INSERT INTO t3 VALUES(2, $dots, $dots);
|
|
SELECT * FROM t3 WHERE i=1;
|
|
|
|
|
|
UPDATE t3 SET k = 'xyz' WHERE i=1;
|
|
SELECT * FROM t3 WHERE i=1;
|
|
|
|
|
|
SELECT * FROM t3 WHERE i=1;
|
|
|
|
|
|
UPDATE t3 SET j = 'xyz' WHERE i=2;
|
|
SELECT * FROM t3 WHERE i=2;
|
|
|
|
|
|
SELECT * FROM t3 WHERE i=2;
|
|
|