Lines Matching refs:tbl
20 # catchsql { DROP TABLE tbl; }
21 catchsql { CREATE TABLE tbl (a, b, c) }
24 CREATE TRIGGER before_tbl_insert BEFORE INSERT ON tbl BEGIN SELECT CASE
28 CREATE TRIGGER after_tbl_insert AFTER INSERT ON tbl BEGIN SELECT CASE
38 INSERT INTO tbl VALUES (5, 5, 6);
39 INSERT INTO tbl VALUES (1, 5, 6);
44 SELECT * FROM tbl;
49 execsql {SELECT * FROM tbl}
56 INSERT INTO tbl VALUES (5, 5, 6);
57 INSERT INTO tbl VALUES (2, 5, 6);
62 SELECT * FROM tbl;
70 INSERT INTO tbl VALUES (5, 5, 6);
71 INSERT INTO tbl VALUES (3, 5, 6);
76 SELECT * FROM tbl;
83 INSERT INTO tbl VALUES (5, 5, 6);
84 INSERT INTO tbl VALUES (4, 5, 6);
89 SELECT * FROM tbl;
95 execsql {DROP TABLE tbl;}
96 execsql {CREATE TABLE tbl (a, b, c);}
97 execsql {INSERT INTO tbl VALUES(1, 2, 3);}
98 execsql {INSERT INTO tbl VALUES(4, 5, 6);}
100 CREATE TRIGGER before_tbl_update BEFORE UPDATE ON tbl BEGIN
104 CREATE TRIGGER before_tbl_delete BEFORE DELETE ON tbl BEGIN
110 UPDATE tbl SET c = 10;
111 SELECT * FROM tbl;
116 DELETE FROM tbl;
117 SELECT * FROM tbl;
125 UPDATE tbl SET c = 10;
133 SELECT * FROM tbl;
138 execsql {CREATE VIEW tbl_view AS SELECT * FROM tbl}
165 catchsql { DROP TABLE tbl; }