mirror of
https://github.com/tursodatabase/libsql.git
synced 2025-05-31 14:02:45 +00:00
31 lines
384 B
Plaintext
31 lines
384 B
Plaintext
|
|
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;
|
|
|