Lines Matching refs:FROM
30 SELECT x FROM t1 ORDER BY y;
34 set r [execsql {SELECT rowid FROM t1 ORDER BY x}]
44 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(1)"
49 set sql "SELECT x FROM t1 WHERE rowid==$x2rowid(3)"
54 set sql "SELECT x FROM t1 WHERE oid==$x2rowid(1)"
59 set sql "SELECT x FROM t1 WHERE OID==$x2rowid(3)"
64 set sql "SELECT x FROM t1 WHERE _rowid_==$x2rowid(1)"
72 execsql "SELECT x FROM t1 WHERE rowid=$norow"
76 set v [execsql {SELECT x, oid FROM t1 order by x}]
82 set v [execsql {SELECT x, RowID FROM t1 order by x}]
88 set v [execsql {SELECT x, _rowid_ FROM t1 order by x}]
98 SELECT rowid, * FROM t1;
104 SELECT rowid, * FROM t1
110 SELECT rowid, * FROM t1 WHERE rowid>1000;
116 SELECT rowid, * FROM t1;
122 SELECT rowid, * FROM t1 WHERE rowid>1000;
128 SELECT rowid, * FROM t1 WHERE rowid>1000;
139 execsql {SELECT x FROM t1 ORDER BY x}
145 execsql {SELECT x FROM t1 ORDER BY x}
176 SELECT * FROM t2 ORDER BY x;
180 execsql {SELECT * FROM t2 ORDER BY rowid}
183 execsql {SELECT rowid, x, y FROM t2 ORDER BY rowid}
186 set r1 [execsql {SELECT _rowid_, rowid FROM t2 ORDER BY rowid}]
188 set r2 [execsql {SELECT _rowid_, rowid FROM t2 ORDER BY x DESC}]
193 set r1 [execsql {SELECT _rowid_, rowid FROM t2 ORDER BY rowid}]
202 DELETE FROM t1;
203 DELETE FROM t2;
208 execsql {INSERT INTO t2 SELECT _rowid_, x*y, y*y FROM t1}
209 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1.rowid==t2.rowid}
212 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1.rowid==t2.rowid}
215 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1.oid==t2.rowid}
218 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
221 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t2.rowid==t1.rowid}
224 execsql {SELECT t2.y FROM t2, t1 WHERE t2.rowid==t1.oid AND t1.x==4}
227 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
230 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t2.rowid==t1.rowid}
233 execsql {SELECT t2.y FROM t1, t2 WHERE t2.rowid==t1.oid AND t1.x==4}
237 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1.rowid==t2.rowid}
240 execsql {SELECT t2.y FROM t1, t2 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
243 execsql {SELECT t2.y FROM t1, t2 WHERE t2.rowid==t1.oid AND 4==t1.x}
246 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1.rowid==t2.rowid}
249 execsql {SELECT t2.y FROM t2, t1 WHERE t1.x==4 AND t1._rowid_==t2.rowid}
252 execsql {SELECT t2.y FROM t2, t1 WHERE t2.rowid==t1.oid AND 4==t1.x}
258 SELECT t1.x FROM t2, t1
265 SELECT t1.x FROM t2, t1
271 SELECT t1.x FROM t1, t2
277 execsql {DELETE FROM t1 WHERE _rowid_ IN (SELECT oid FROM t1 WHERE x>8)}
278 execsql {SELECT max(x) FROM t1}
285 SELECT x FROM t1
290 if {[execsql "SELECT x FROM t1 WHERE rowid=$::norow"]==""} break
293 DELETE FROM t1 WHERE rowid=$::norow
298 SELECT x FROM t1
309 DELETE FROM t1;
313 SELECT rowid, * FROM t1;
319 SELECT rowid,* FROM t1
326 SELECT * FROM t2;
332 SELECT * FROM t2;
339 SELECT * FROM t2;
346 SELECT b FROM t2 ORDER BY b;
351 SELECT b FROM t2 WHERE a NOT IN(1,2,1000000,1000001,2147483647);
360 SELECT b FROM t2 WHERE a NOT IN(1,2,1000000,1000001,2147483647) ORDER BY b;
365 DELETE FROM t2 WHERE a!=2;
367 SELECT * FROM t2;
382 SELECT * FROM t3;
387 SELECT rowid, * FROM t4;
398 SELECT * FROM t3;
403 SELECT rowid, * FROM t4;
414 SELECT * FROM t3;
419 SELECT rowid, * FROM t4;
428 SELECT * FROM t3 WHERE a<123.5
433 SELECT * FROM t3 WHERE a<124.5
438 SELECT * FROM t3 WHERE a>123.5
443 SELECT * FROM t3 WHERE a>122.5
448 SELECT * FROM t3 WHERE a==123.5
453 SELECT * FROM t3 WHERE a==123.000
458 SELECT * FROM t3 WHERE a>100.5 AND a<200.5
463 SELECT * FROM t3 WHERE a>'xyz';
468 SELECT * FROM t3 WHERE a<'xyz';
473 SELECT * FROM t3 WHERE a>=122.9 AND a<=123.1
485 INSERT INTO t5 SELECT a+2 FROM t5;
486 INSERT INTO t5 SELECT a+4 FROM t5;
487 SELECT rowid, * FROM t5;
491 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.5}
494 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.0}
497 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.5}
500 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.0}
503 execsql {SELECT rowid, a FROM t5 WHERE 5.5<=rowid}
506 execsql {SELECT rowid, a FROM t5 WHERE 5.5<rowid}
509 execsql {SELECT rowid, a FROM t5 WHERE rowid<=5.5}
512 execsql {SELECT rowid, a FROM t5 WHERE rowid<5.5}
515 execsql {SELECT rowid, a FROM t5 WHERE 5.5>=rowid}
518 execsql {SELECT rowid, a FROM t5 WHERE 5.5>rowid}
521 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.5 ORDER BY rowid DESC}
524 execsql {SELECT rowid, a FROM t5 WHERE rowid>=5.0 ORDER BY rowid DESC}
527 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.5 ORDER BY rowid DESC}
530 execsql {SELECT rowid, a FROM t5 WHERE rowid>5.0 ORDER BY rowid DESC}
533 execsql {SELECT rowid, a FROM t5 WHERE 5.5<=rowid ORDER BY rowid DESC}
536 execsql {SELECT rowid, a FROM t5 WHERE 5.5<rowid ORDER BY rowid DESC}
539 execsql {SELECT rowid, a FROM t5 WHERE rowid<=5.5 ORDER BY rowid DESC}
542 execsql {SELECT rowid, a FROM t5 WHERE rowid<5.5 ORDER BY rowid DESC}
545 execsql {SELECT rowid, a FROM t5 WHERE 5.5>=rowid ORDER BY rowid DESC}
548 execsql {SELECT rowid, a FROM t5 WHERE 5.5>rowid ORDER BY rowid DESC}
554 INSERT INTO t6(rowid,a) SELECT -a,a FROM t5;
555 SELECT rowid, * FROM t6;
559 execsql {SELECT rowid, a FROM t6 WHERE rowid>=-5.5}
562 execsql {SELECT rowid, a FROM t6 WHERE rowid>=-5.0}
565 execsql {SELECT rowid, a FROM t6 WHERE rowid>=-5.5 ORDER BY rowid DESC}
568 execsql {SELECT rowid, a FROM t6 WHERE rowid>=-5.0 ORDER BY rowid DESC}
571 execsql {SELECT rowid, a FROM t6 WHERE -5.5<=rowid}
574 execsql {SELECT rowid, a FROM t6 WHERE -5.5<=rowid ORDER BY rowid DESC}
577 execsql {SELECT rowid, a FROM t6 WHERE rowid>-5.5}
580 execsql {SELECT rowid, a FROM t6 WHERE rowid>-5.0}
583 execsql {SELECT rowid, a FROM t6 WHERE rowid>-5.5 ORDER BY rowid DESC}
586 execsql {SELECT rowid, a FROM t6 WHERE rowid>-5.0 ORDER BY rowid DESC}
589 execsql {SELECT rowid, a FROM t6 WHERE -5.5<rowid}
592 execsql {SELECT rowid, a FROM t6 WHERE -5.5<rowid ORDER BY rowid DESC}
595 execsql {SELECT rowid, a FROM t6 WHERE rowid<=-5.5}
598 execsql {SELECT rowid, a FROM t6 WHERE rowid<=-5.5 ORDER BY rowid DESC}
601 execsql {SELECT rowid, a FROM t6 WHERE -5.5>=rowid}
604 execsql {SELECT rowid, a FROM t6 WHERE -5.5>=rowid ORDER BY rowid DESC}
607 execsql {SELECT rowid, a FROM t6 WHERE rowid<-5.5}
610 execsql {SELECT rowid, a FROM t6 WHERE rowid<-5.5 ORDER BY rowid DESC}
613 execsql {SELECT rowid, a FROM t6 WHERE -5.5>rowid}
616 execsql {SELECT rowid, a FROM t6 WHERE -5.5>rowid ORDER BY rowid DESC}
622 execsql {SELECT rowid, a FROM t5 WHERE rowid>'abc'}
625 execsql {SELECT rowid, a FROM t5 WHERE rowid>='abc'}
628 execsql {SELECT rowid, a FROM t5 WHERE rowid<'abc'}
631 execsql {SELECT rowid, a FROM t5 WHERE rowid<='abc'}