mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-12 15:33:44 +00:00
19 lines
304 B
Plaintext
19 lines
304 B
Plaintext
|
|
DELETE FROM t3 WHERE x IS NOT NULL AND +rowid=6;
|
|
|
|
|
|
CREATE TABLE t1(a INTEGER, b INT, c DEFAULT 0);
|
|
|
|
|
|
PRAGMA journal_mode = memory;
|
|
INSERT INTO t1 VALUES(1,2,3);
|
|
PRAGMA journal_mode=PERSIST;
|
|
|
|
|
|
INSERT INTO t1 VALUES(4, 5, 6);
|
|
|
|
|
|
PRAGMA journal_mode=MEMORY;
|
|
INSERT INTO t1 VALUES(7, 8, 9);
|
|
|