mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 22:39:05 +00:00
40 lines
908 B
Plaintext
40 lines
908 B
Plaintext
|
|
SELECT rowid FROM xt1 WHERE a IS NOT NULL;
|
|
|
|
|
|
SELECT a,b,c,d FROM t1 EXCEPT SELECT rowid,b,c,d FROM xt1;
|
|
SELECT rowid,b,c,d FROM xt1 EXCEPT SELECT a,b,c,d FROM t1;
|
|
|
|
|
|
DELETE FROM xt1 WHERE rowid=5;
|
|
INSERT INTO xt1(rowid,a,b,c,d) VALUES(99,'hello',1099,2022,NULL);
|
|
SELECT * FROM chnglog ORDER BY rowid;
|
|
|
|
|
|
PRAGMA integrity_check;
|
|
|
|
|
|
PRAGMA integrity_check;
|
|
|
|
|
|
PRAGMA integrity_check;
|
|
|
|
|
|
DELETE FROM t1;
|
|
WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<10)
|
|
INSERT INTO t1(a,b,c,d) SELECT i,i,i,i FROM c;
|
|
UPDATE xt1c SET c=NULL WHERE rowid=5;
|
|
PRAGMA integrity_check;
|
|
|
|
|
|
DELETE FROM t1;
|
|
WITH RECURSIVE c(i) AS (VALUES(1) UNION ALL SELECT i+1 FROM c WHERE i<10)
|
|
INSERT INTO t1(a,b,c,d) SELECT i,i,i,i FROM c;
|
|
UPDATE xt1c SET c=99 WHERE rowid IN (5,7,9);
|
|
SELECT c FROM t1 ORDER BY c;
|
|
|
|
|
|
UPDATE xt1 SET c=99 WHERE rowid IN (5,7,9);
|
|
PRAGMA integrity_check;
|
|
|