Lines Matching refs:tbl
136 catchsql {drop table tbl; drop view vw}
138 create table tbl(a integer primary key, b integer);
139 create view vw as select * from tbl;
141 delete from tbl where a = old.a;
144 update tbl set a=new.a, b=new.b where a = old.a;
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;