Lines Matching refs:log

30   CREATE TABLE log(x, a, b);
40     INSERT INTO log VALUES('after insert', new.a, new.b);
43     INSERT INTO log VALUES('after update', new.a, new.b);
46     INSERT INTO log VALUES('after delete', old.a, old.b);
55   SELECT x, a, b FROM log;
59   DELETE FROM log;
69   SELECT x, a, b FROM log;
76   DELETE FROM log;
80   SELECT x, a, b FROM log;
96     DELETE FROM log;
101     SELECT x, a, b FROM log;
108     CREATE TABLE log(x, a, b);
117       INSERT INTO log VALUES('after insert', new.a, new.b);
120       INSERT INTO log VALUES('after delete', old.a, old.b);
129     SELECT * FROM log;
136     DELETE FROM log;
139     SELECT * FROM log;
144       INSERT INTO log VALUES('after update', new.a, new.b);
162     DELETE FROM log;
166     SELECT * FROM log;