Lines Matching refs:log

143   CREATE TABLE log(x);
147     INSERT INTO log VALUES('insert');
150     INSERT INTO log VALUES('delete');
153     INSERT INTO log VALUES('update');
168   -- None of the inserts on table log were counted.
169   SELECT count(*) FROM log
239   CREATE TABLE log(log);
247     INSERT INTO log VALUES('insert');
250     INSERT INTO log VALUES('update'), ('update');
253     INSERT INTO log VALUES('delete'), ('delete'), ('delete');
308   CREATE TABLE log(x);
313     INSERT INTO log VALUES(old.b || ' -> ' || new.b || ' c = ' || changes() );
323   SELECT * FROM log;
340   CREATE TABLE log(x);
344     INSERT INTO log VALUES('t2->' || changes());
349     INSERT INTO log VALUES('t3->' || changes());
354     INSERT INTO log VALUES('t2->' || changes());
359     INSERT INTO log VALUES('t3->' || changes());
364     INSERT INTO log VALUES('t2->' || changes());
369     INSERT INTO log VALUES('t3->' || changes());
375   SELECT * FROM log;
379   DELETE FROM log;
381   SELECT * FROM log;
385   DELETE FROM log;
387   SELECT * FROM log;