Lines Matching refs:log

233   {INSERT INTO log VALUES(new.c, 2, 3);}
234   {DELETE FROM log WHERE a = 1;}
237     DELETE FROM log;}
238   {INSERT INTO log select * from tbl;} 
303       DROP TABLE log;
308       CREATE TABLE log(a, b, c);
311     set query {SELECT * FROM tbl; SELECT * FROM log;}
312     set prep "$prep; INSERT INTO log VALUES(1, 2, 3);\
313              INSERT INTO log VALUES(10, 20, 30);"
319     execsql "DELETE FROM tbl; DELETE FROM log; $prep";
326     execsql "DELETE FROM tbl; DELETE FROM log;"
331     execsql "DELETE FROM tbl; DELETE FROM log; $prep";
343   DROP TABLE log;
351   CREATE TABLE log (a);
352   INSERT INTO log VALUES (0);
357       UPDATE log SET a = a + 1;
366     SELECT * FROM log;
371   DROP TABLE log;
383   CREATE TABLE log (a);
384   INSERT INTO log VALUES (0);
388   execsql "CREATE TRIGGER $trig BEGIN UPDATE log set a = a + 1; END;"
400     SELECT * FROM log;
401     UPDATE log SET a = 0;
404     SELECT * FROM log;
405     UPDATE log SET a = 0;
408     SELECT * FROM log;
409     UPDATE log SET a = 0;
414   DROP TABLE log;