mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 20:20:20 +00:00
34 lines
409 B
Plaintext
34 lines
409 B
Plaintext
|
|
PRAGMA journal_mode = WAL;
|
|
|
|
|
|
PRAGMA journal_mode = WAL;
|
|
|
|
|
|
CREATE TABLE t1(x, y);
|
|
INSERT INTO t1 VALUES(1, 2);
|
|
|
|
|
|
SELECT * FROM t1;
|
|
|
|
|
|
SELECT * FROM t1;
|
|
|
|
|
|
PRAGMA journal_mode = DELETE;
|
|
SELECT * FROM t1;
|
|
|
|
|
|
SELECT * FROM t1;
|
|
|
|
|
|
INSERT INTO t1 VALUES(5, 6);
|
|
|
|
|
|
SELECT * FROM t1;
|
|
|
|
CREATE TABLE t1(x, y)
|
|
PRAGMA journal_mode = wAL
|
|
INSERT INTO t1 VALUES(1, 1);
|
|
PRAGMA journal_mode = delete
|