0
0
mirror of https://github.com/tursodatabase/libsql.git synced 2025-03-01 23:31:26 +00:00

31 lines
384 B
Plaintext
Raw Permalink Normal View History

CREATE TABLE t1(a);
INSERT INTO t1 VALUES(123),(456);
SELECT a FROM t1 ORDER BY a;
PRAGMA query_only;
PRAGMA query_only=ON;
PRAGMA query_only;
SELECT a FROM t1 ORDER BY a;
PRAGMA query_only;
PRAGMA query_only=OFF;
PRAGMA query_only;
INSERT INTO t1 VALUES(789);
SELECT a FROM t1 ORDER BY a;
UPDATE t1 SET a=a+1;
SELECT a FROM t1 ORDER BY a;