Lines Matching refs:FROM

37     SELECT name FROM sqlite_master
49     SELECT name FROM sqlite_master
65     SELECT * FROM t1;
70     SELECT rowid, * FROM t1;
85     SELECT rowid, * FROM t1;
99     SELECT rowid, * FROM t1;
109     SELECT b FROM t1 ORDER BY b;
118     SELECT * FROM t1;
127     SELECT * FROM t1 WHERE a==4;
159   execsql {SELECT * FROM t1}
168     SELECT * FROM t1 WHERE b=='y'
173     SELECT * FROM t1 WHERE b=='y' AND rowid<0
178     SELECT * FROM t1 WHERE b=='y' AND rowid<0 AND rowid>=-20
183     SELECT * FROM t1 WHERE b>='y'
188     SELECT * FROM t1 WHERE b>='y' AND rowid<10
195     SELECT * FROM t1 WHERE b=='y';
200     SELECT rowid, * FROM t1;
205     SELECT rowid, * FROM t1 WHERE b<'second'
210     SELECT rowid, * FROM t1 WHERE 'second'>b
215     SELECT rowid, * FROM t1 WHERE 8>rowid AND 'second'>b
220     SELECT rowid, * FROM t1 WHERE 8>rowid AND 'second'>b AND 0<rowid
225     SELECT rowid, * FROM t1 WHERE b>'a'
230     DELETE FROM t1 WHERE rowid=4;
231     SELECT * FROM t1 WHERE b>'a';
237     SELECT * FROM t1 WHERE b>'a';
242     SELECT * FROM t1
263     SELECT * FROM t1 WHERE a=5;
268     SELECT * FROM t1 WHERE a>4 AND a<6;
273     SELECT * FROM t1 WHERE b>='hello' AND b<'hello2';
283     SELECT * FROM t1 WHERE c=='world';
289     SELECT * FROM t1 WHERE c=='world';
294     SELECT * FROM t1 WHERE c=='world' AND a>7;
299     SELECT * FROM t1 WHERE 7<a;
307     SELECT * FROM t1 WHERE 11=rowid
312     SELECT * FROM t1 WHERE 11=rowid AND b=='hello'
317     SELECT * FROM t1 WHERE 11=rowid AND b=='hello' AND c IS NOT NULL;
322     SELECT * FROM t1 WHERE rowid==11
327     SELECT * FROM t1 WHERE oid==11 AND b=='hello'
332     SELECT * FROM t1 WHERE a==11 AND b=='hello' AND c IS NOT NULL;
338     SELECT * FROM t1 WHERE 8<rowid;
343     SELECT * FROM t1 WHERE 8<rowid AND 11>=oid;
348     SELECT * FROM t1 WHERE 11<=_rowid_ AND 12>=a;
353     SELECT * FROM t1 WHERE 0>=_rowid_;
358     SELECT * FROM t1 WHERE a<0;
363     SELECT * FROM t1 WHERE a<0 AND a>10;
374     SELECT * FROM t1 WHERE a=0;
379     SELECT rowid, a FROM t1
393     COPY t1 FROM 'data1.txt';
394     SELECT * FROM t1 WHERE a>=20;
399     SELECT * FROM t1 WHERE b=='hello'
404     DELETE FROM t1 WHERE b='b-21';
405     SELECT * FROM t1 WHERE b=='b-21';
410     SELECT * FROM t1 WHERE a>=20
419     SELECT * FROM t1 WHERE rowid>=30;
424     SELECT * FROM t1 WHERE rowid>20;
433     INSERT INTO t2 SELECT * FROM t1;
434     SELECT rowid FROM t2;
439     SELECT x FROM t2;
446     SELECT rowid, a, c FROM t1 WHERE c=='www';
469     INSERT INTO t2 SELECT NULL, z, y FROM t2;
470     SELECT * FROM t2;
479     SELECT b FROM t1 WHERE a=2.0+3.0;
484     SELECT b FROM t1 WHERE a=2.0+3.5;