Lines Matching refs:INSERT

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);
56         INSERT INTO tbl VALUES (5, 5, 6);
57         INSERT INTO tbl VALUES (2, 5, 6);
70         INSERT INTO tbl VALUES (5, 5, 6);
71         INSERT INTO tbl VALUES (3, 5, 6);
83         INSERT INTO tbl VALUES (5, 5, 6);
84         INSERT INTO tbl VALUES (4, 5, 6);
97 execsql {INSERT INTO tbl VALUES(1, 2, 3);}
98 execsql {INSERT INTO tbl VALUES(4, 5, 6);}
124     CREATE TRIGGER after_tbl2_insert AFTER INSERT ON tbl2 BEGIN
126         INSERT INTO tbl2 VALUES (new.a, new.b, new.c);
131 	INSERT INTO tbl2 VALUES (1, 2, 3);
140     CREATE TRIGGER tbl_view_insert INSTEAD OF INSERT ON tbl_view BEGIN
149 	INSERT INTO tbl_view VALUES(1, 2, 3);
154 	INSERT INTO tbl_view VALUES(2, 2, 3);
159 	INSERT INTO tbl_view VALUES(3, 2, 3);