Lines Matching refs:tbl

28 catchsql { CREATE TABLE tbl(a, b ,c) }
30     CREATE TRIGGER before_tbl_insert BEFORE INSERT ON tbl BEGIN SELECT CASE 
34     CREATE TRIGGER after_tbl_insert AFTER INSERT ON tbl BEGIN SELECT CASE 
44         INSERT INTO tbl VALUES (5, 5, 6);
45         INSERT INTO tbl VALUES (1, 5, 6);
51         SELECT * FROM tbl;
56     execsql {SELECT * FROM tbl}
63         INSERT INTO tbl VALUES (5, 5, 6);
64         INSERT INTO tbl VALUES (2, 5, 6);
70         SELECT * FROM tbl;
78         INSERT INTO tbl VALUES (5, 5, 6);
79         INSERT INTO tbl VALUES (3, 5, 6);
85         SELECT * FROM tbl;
95         INSERT INTO tbl VALUES (3, 9, 10);
100     execsql {SELECT * FROM tbl}
107         INSERT INTO tbl VALUES (5, 5, 6);
108         INSERT INTO tbl VALUES (4, 5, 6);
113         SELECT * FROM tbl;
119 execsql {DROP TABLE tbl;}
120 execsql {CREATE TABLE tbl (a, b, c);}
121 execsql {INSERT INTO tbl VALUES(1, 2, 3);}
122 execsql {INSERT INTO tbl VALUES(4, 5, 6);}
124     CREATE TRIGGER before_tbl_update BEFORE UPDATE ON tbl BEGIN
128     CREATE TRIGGER before_tbl_delete BEFORE DELETE ON tbl BEGIN
134         UPDATE tbl SET c = 10;
135         SELECT * FROM tbl;
140         DELETE FROM tbl;
141         SELECT * FROM tbl;
149         UPDATE tbl SET c = 10;
157         SELECT * FROM tbl;
165 execsql {CREATE VIEW tbl_view AS SELECT * FROM tbl}
196 catchsql { DROP TABLE tbl; }