Lines Matching refs:select

27       select test1.id as id,a as a,b as b
35     select * from test1;
40     select * from test2;
48     select * from test1;
53     select * from test2;
65     select * from test1;
70     select * from test2;
78     select * from test1;
83     select * from test2;
107     select * from test1;
114     select * from test1;
119     select * from test2;
127     select * from test2;
139 	create view vw as select * from tbl;
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;
157 	select count(*) from vw;
161     execsql {select a, b from vw where a<103 or a>226 order by a}
169     execsql {select * from vw}
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;
185     execsql {select count(*) from vw}
193     execsql {select a, b from vw where a<=102 or a>=227 order by a}