Lines Matching refs:f1
39 execsql {CREATE TABLE table1(f1 int, f2 int)}
44 execsql {SELECT * FROM table1 ORDER BY f1}
47 execsql {DELETE FROM table1 WHERE f1=3}
50 execsql {SELECT * FROM table1 ORDER BY f1}
53 execsql {CREATE INDEX index1 ON table1(f1)}
55 execsql {DELETE FROM 'table1' WHERE f1=3}
58 execsql {SELECT * FROM table1 ORDER BY f1}
61 execsql {DELETE FROM table1 WHERE f1=2}
64 execsql {SELECT * FROM table1 ORDER BY f1}
72 execsql {CREATE TABLE table2(f1 int, f2 int)}
78 set v [catch {execsql {DELETE FROM table2 WHERE xyzzy(f1+4)}} msg]
127 execsql "DELETE FROM table1 WHERE f1==$i"
132 execsql "DELETE FROM table1 WHERE f1>50"
137 execsql "DELETE FROM table1 WHERE f1==$i"
139 execsql {SELECT f1 FROM table1 ORDER BY f1}
143 execsql "DELETE FROM table1 WHERE f1==$i"
145 execsql {SELECT f1 FROM table1 ORDER BY f1}
148 execsql "DELETE FROM table1 WHERE f1!=48"
149 execsql {SELECT f1 FROM table1 ORDER BY f1}
174 execsql {SELECT f1 FROM table1 WHERE f1<10 ORDER BY f1}
177 execsql {SELECT f1 FROM table2 WHERE f1<10 ORDER BY f1}
180 execsql {DELETE FROM table1 WHERE f1>7}
181 execsql {SELECT f1 FROM table1 ORDER BY f1}
184 execsql {DELETE FROM table2 WHERE f1>7}
185 execsql {SELECT f1 FROM table2 ORDER BY f1}
189 execsql {SELECT f1 FROM table1}
193 execsql {SELECT f1 FROM table1}
197 execsql {SELECT f1 FROM table2}
201 execsql {SELECT f1 FROM table2}