mirror of
https://github.com/tursodatabase/libsql.git
synced 2025-07-14 05:35:29 +00:00
26 lines
525 B
Plaintext
26 lines
525 B
Plaintext
|
|
CREATE TABLE t1(a, b);
|
|
INSERT INTO t1 VALUES(1, 2);
|
|
PRAGMA journal_mode = DELETE;
|
|
|
|
|
|
INSERT INTO t1 VALUES(3, 4);
|
|
PRAGMA journal_mode = WAL;
|
|
|
|
INSERT INTO t1 VALUES(3, 4)
|
|
PRAGMA wal_checkpoint
|
|
|
|
ATTACH 'test.db2' AS aux;
|
|
PRAGMA aux.journal_mode = wal;
|
|
CREATE TABLE aux.t2(x, y);
|
|
INSERT INTO aux.t2 VALUES('a', 'b');
|
|
PRAGMA schema_version = 450;
|
|
DETACH aux;
|
|
|
|
PRAGMA main.journal_mode = wal;
|
|
CREATE TABLE t1(a, b);
|
|
INSERT INTO t1 VALUES(1, 2);
|
|
INSERT INTO t1 VALUES(3, 4);
|
|
SELECT * FROM t1;
|
|
|