Lines Matching refs:log

229   {INSERT INTO log VALUES(new.c, 2, 3);}
230   {DELETE FROM log WHERE a = 1;}
233     DELETE FROM log;}
234   {INSERT INTO log select * from tbl;} 
299       DROP TABLE log;
304       CREATE TABLE log(a, b, c);
307     set query {SELECT * FROM tbl; SELECT * FROM log;}
308     set prep "$prep; INSERT INTO log VALUES(1, 2, 3);\
309              INSERT INTO log VALUES(10, 20, 30);"
315     execsql "DELETE FROM tbl; DELETE FROM log; $prep";
322     execsql "DELETE FROM tbl; DELETE FROM log;"
327     execsql "DELETE FROM tbl; DELETE FROM log; $prep";
339   DROP TABLE log;
347   CREATE TABLE log (a);
348   INSERT INTO log VALUES (0);
353       UPDATE log SET a = a + 1;
362     SELECT * FROM log;
367   DROP TABLE log;
379   CREATE TABLE log (a);
380   INSERT INTO log VALUES (0);
384   execsql "CREATE TRIGGER $trig BEGIN UPDATE log set a = a + 1; END;"
396     SELECT * FROM log;
397     UPDATE log SET a = 0;
400     SELECT * FROM log;
401     UPDATE log SET a = 0;
404     SELECT * FROM log;
405     UPDATE log SET a = 0;
410   DROP TABLE log;