Lines Matching refs:FROM

15 # focus of this file is testing the DELETE FROM statement.
25   set v [catch {execsql {DELETE FROM test1}} msg]
32   set v [catch {execsql {DELETE FROM sqlite_master}} msg]
44   execsql {SELECT * FROM table1 ORDER BY f1}
47   execsql {DELETE FROM table1 WHERE f1=3}
50   execsql {SELECT * FROM table1 ORDER BY 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}
73   set v [catch {execsql {DELETE FROM table2 WHERE f3=5}} msg]
78   set v [catch {execsql {DELETE FROM table2 WHERE xyzzy(f1+4)}} msg]
86   execsql {DELETE FROM table1}
89   execsql {SELECT count(*) FROM table1}
97   execsql {SELECT count(*) FROM table1}
100   execsql {DELETE FROM table1}
108   execsql {SELECT count(*) FROM table1}
112   execsql {DELETE FROM table1}
115   execsql {SELECT count(*) FROM table1}
123   execsql {SELECT count(*) FROM table1}
127      execsql "DELETE FROM table1 WHERE f1==$i"
129   execsql {SELECT count(*) FROM table1}
132   execsql "DELETE FROM table1 WHERE f1>50"
133   execsql {SELECT count(*) FROM table1}
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}
163   execsql {DELETE FROM table1}
164   execsql {COPY table1 FROM 'data1.txt'}
165   execsql {DELETE FROM table2}
166   execsql {COPY table2 FROM 'data1.txt'}
168   execsql {SELECT count(*) FROM table1}
171   execsql {SELECT count(*) FROM table2}
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}
188   execsql {DELETE FROM table1}
189   execsql {SELECT f1 FROM table1}
193   execsql {SELECT f1 FROM table1}
196   execsql {DELETE FROM table2}
197   execsql {SELECT f1 FROM table2}
201   execsql {SELECT f1 FROM table2}
209     INSERT INTO t3 SELECT a+1 FROM t3;
210     INSERT INTO t3 SELECT a+2 FROM t3;
211     SELECT * FROM t3;
221     DELETE FROM t3 WHERE a<2;
222     SELECT * FROM t3;
227     SELECT * FROM cnt;
232     DELETE FROM t3;
233     SELECT * FROM t3;
238     SELECT * FROM cnt;
244     INSERT INTO t3 SELECT a+1 FROM t3;
245     INSERT INTO t3 SELECT a+2 FROM t3;
246     CREATE TABLE t4 AS SELECT * FROM t3;
248     DELETE FROM t3;
249     DELETE FROM t4;
261     SELECT * FROM t3;
270     DELETE FROM t3;
274   execsql {SELECT * FROM t3} 
278     DELETE FROM t3 WHERE 1;
282   execsql {SELECT * FROM t3} 
286     DELETE FROM t3 WHERE a<100;
290   execsql {SELECT * FROM t3}