mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-12 15:33:44 +00:00
31 lines
571 B
Plaintext
31 lines
571 B
Plaintext
|
|
PRAGMA journal_mode = wal;
|
|
CREATE TABLE t1(a, b, c);
|
|
INSERT INTO t1 VALUES(1, 2, 3);
|
|
INSERT INTO t1 VALUES(4, 5, 6);
|
|
|
|
SELECT * FROM t1
|
|
SELECT * FROM t1
|
|
|
|
CREATE TABLE t1(x);
|
|
PRAGMA journal_mode = wal;
|
|
INSERT INTO t1 VALUES(1);
|
|
INSERT INTO t1 VALUES(2);
|
|
|
|
|
|
PRAGMA journal_mode = wal;
|
|
CREATE TABLE t1(x, y);
|
|
INSERT INTO t1 VALUES('a', 'b');
|
|
INSERT INTO t1 VALUES('c', 'd');
|
|
|
|
|
|
SELECT * FROM t1;
|
|
|
|
|
|
CREATE TABLE t2(x);
|
|
PRAGMA journal_mode = wal;
|
|
INSERT INTO t2 VALUES('abc');
|
|
INSERT INTO t2 VALUES('def');
|
|
INSERT INTO t2 VALUES('ghi');
|
|
|