Lines Matching refs:from
46 select last_insert_rowid(); -- returns 3 from above.
58 # LIRID unchanged after a delete from a table
61 delete from t1 where k=4;
76 create view v as select * from t1;
96 delete from t2;
110 select val1 from t2;
117 select val2 from t2;
124 select val3 from t2;
134 delete from t2;
149 select val1 from t2;
156 select val2 from t2;
163 select val3 from t2;
176 delete from t2;
191 select val1 from t2;
198 select val2 from t2;
205 select val3 from t2;
219 delete from t2;
225 delete from t1 where k=1;
233 select val1 from t2;
240 select val2 from t2;
247 select val3 from t2;
259 delete from t2;
274 select val1 from t2;
281 select val2 from t2;
288 select val3 from t2;
303 create temp view v1 as select * from t1;
304 create temp view v2 as select * from t2;
333 select rin from rid where k=1;
339 select rout from rid where k=1;
345 select rin from rid where k=2;
351 select rout from rid where k=2;