Lines Matching refs:insert
29 create trigger I_test instead of insert on test
31 insert into test1 (id,a) values (NEW.id,NEW.a);
32 insert into test2 (id,b) values (NEW.id,NEW.b);
34 insert into test values(1,2,3);
47 insert into test values(4,5,6);
90 insert into test values(7,8,9);
97 insert into test values(7,8,9);
113 insert into test values(7,8,9);
146 create trigger t_ins_tbl instead of insert on vw for each row begin
147 insert into tbl values (new.a,new.b);
149 insert into tbl values(101,1001);
150 insert into tbl values(102,1002);
151 insert into tbl select a+2, b+2 from tbl;
152 insert into tbl select a+4, b+4 from tbl;
153 insert into tbl select a+8, b+8 from tbl;
154 insert into tbl select a+16, b+16 from tbl;
155 insert into tbl select a+32, b+32 from tbl;
156 insert into tbl select a+64, b+64 from tbl;
172 #test insert into view
175 insert into vw values(102,1002);
176 insert into vw select a+2, b+2 from vw;
177 insert into vw select a+4, b+4 from vw;
178 insert into vw select a+8, b+8 from vw;
179 insert into vw select a+16, b+16 from vw;
180 insert into vw select a+32, b+32 from vw;
181 insert into vw select a+64, b+64 from vw;