Lines Matching refs:f1

36   execsql {CREATE TABLE table1(f1 int, f2 int)}
41   execsql {SELECT * FROM table1 ORDER BY f1}
44   execsql {DELETE FROM table1 WHERE f1=3}
47   execsql {SELECT * FROM table1 ORDER BY f1}
50   execsql {CREATE INDEX index1 ON table1(f1)}
53     execsql {EXPLAIN DELETE FROM table1 WHERE f1=3}
55   execsql {DELETE FROM 'table1' WHERE f1=3}
58   execsql {SELECT * FROM table1 ORDER BY f1}
61   execsql {DELETE FROM table1 WHERE f1=2}
67   execsql {SELECT * FROM table1 ORDER BY f1}
74   execsql {CREATE TABLE table2(f1 int, f2 int)}
80   set v [catch {execsql {DELETE FROM table2 WHERE xyzzy(f1+4)}} msg]
129      execsql "DELETE FROM table1 WHERE f1==$i"
134   execsql "DELETE FROM table1 WHERE f1>50"
136 } [db one {SELECT count(*) FROM table1 WHERE f1>50}]
142      execsql "DELETE FROM table1 WHERE f1==$i"
144   execsql {SELECT f1 FROM table1 ORDER BY f1}
148      execsql "DELETE FROM table1 WHERE f1==$i"
150   execsql {SELECT f1 FROM table1 ORDER BY f1}
153   execsql "DELETE FROM table1 WHERE f1!=48"
154   execsql {SELECT f1 FROM table1 ORDER BY f1}
178   execsql {SELECT f1 FROM table1 WHERE f1<10 ORDER BY f1}
181   execsql {SELECT f1 FROM table2 WHERE f1<10 ORDER BY f1}
184   execsql {DELETE FROM table1 WHERE f1>7}
188   execsql {SELECT f1 FROM table1 ORDER BY f1}
191   execsql {DELETE FROM table2 WHERE f1>7}
192   execsql {SELECT f1 FROM table2 ORDER BY f1}
196   execsql {SELECT f1 FROM table1}
200   execsql {SELECT f1 FROM table1}
204   execsql {SELECT f1 FROM table2}
208   execsql {SELECT f1 FROM table2}