Lines Matching refs:INSERT
22 CREATE TRIGGER before_tbl_insert BEFORE INSERT ON tbl BEGIN SELECT CASE
26 CREATE TRIGGER after_tbl_insert AFTER INSERT ON tbl BEGIN SELECT CASE
36 INSERT INTO tbl VALUES (5, 5, 6);
37 INSERT INTO tbl VALUES (1, 5, 6);
54 INSERT INTO tbl VALUES (5, 5, 6);
55 INSERT INTO tbl VALUES (2, 5, 6);
68 INSERT INTO tbl VALUES (5, 5, 6);
69 INSERT INTO tbl VALUES (3, 5, 6);
81 INSERT INTO tbl VALUES (5, 5, 6);
82 INSERT INTO tbl VALUES (4, 5, 6);
95 execsql {INSERT INTO tbl VALUES(1, 2, 3);}
96 execsql {INSERT INTO tbl VALUES(4, 5, 6);}
122 CREATE TRIGGER after_tbl2_insert AFTER INSERT ON tbl2 BEGIN
124 INSERT INTO tbl2 VALUES (new.a, new.b, new.c);
129 INSERT INTO tbl2 VALUES (1, 2, 3);
138 CREATE TRIGGER tbl_view_insert INSTEAD OF INSERT ON tbl_view BEGIN
147 INSERT INTO tbl_view VALUES(1, 2, 3);
152 INSERT INTO tbl_view VALUES(2, 2, 3);
157 INSERT INTO tbl_view VALUES(3, 2, 3);