Lines Matching refs:log
202 {INSERT INTO log VALUES(new.c, 2, 3);}
203 {DELETE FROM log WHERE a = 1;}
206 DELETE FROM log;}
207 {INSERT INTO log select * from tbl;}
272 DROP TABLE log;
277 CREATE TABLE log(a, b, c);
280 set query {SELECT * FROM tbl; SELECT * FROM log;}
281 set prep "$prep; INSERT INTO log VALUES(1, 2, 3);\
282 INSERT INTO log VALUES(10, 20, 30);"
288 execsql "DELETE FROM tbl; DELETE FROM log; $prep";
295 execsql "DELETE FROM tbl; DELETE FROM log;"
300 execsql "DELETE FROM tbl; DELETE FROM log; $prep";
317 DROP TABLE log;
325 CREATE TABLE log (a);
326 INSERT INTO log VALUES (0);
331 UPDATE log SET a = a + 1;
340 SELECT * FROM log;
345 DROP TABLE log;
355 CREATE TABLE log (a);
356 INSERT INTO log VALUES (0);
360 execsql "CREATE TRIGGER $trig BEGIN UPDATE log set a = a + 1; END;"
367 SELECT * FROM log;
368 UPDATE log SET a = 0;
371 SELECT * FROM log;
372 UPDATE log SET a = 0;
375 SELECT * FROM log;
376 UPDATE log SET a = 0;
381 DROP TABLE log;