mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 19:09:41 +00:00
34 lines
450 B
Plaintext
34 lines
450 B
Plaintext
|
|
CREATE TABLE t1(x, y);
|
|
INSERT INTO t1 VALUES(1, 2);
|
|
|
|
|
|
PRAGMA journal_mode = WAL;
|
|
SELECT * FROM t1;
|
|
|
|
|
|
PRAGMA journal_mode = WAL;
|
|
SELECT * FROM t1;
|
|
|
|
INSERT INTO t1 VALUES(3, 4)
|
|
|
|
|
|
|
|
PRAGMA journal_mode = delete;
|
|
|
|
|
|
|
|
|
|
SELECT * FROM t1;
|
|
|
|
|
|
CREATE TABLE t2(x, y);
|
|
INSERT INTO t2 VALUES('a', 'b');
|
|
INSERT INTO t2 VALUES('c', 'd');
|
|
|
|
|
|
PRAGMA journal_mode = WAL;
|
|
INSERT INTO t2 VALUES('e', 'f');
|
|
INSERT INTO t2 VALUES('g', 'h');
|
|
|