Lines Matching refs:DELETE
13 # focus of this file is testing the DELETE FROM statement.
23 set v [catch {execsql {DELETE FROM test1}} msg]
30 set v [catch {execsql {DELETE FROM sqlite_master}} msg]
45 execsql {DELETE FROM table1 WHERE f1=3}
53 execsql {DELETE FROM 'table1' WHERE f1=3}
59 execsql {DELETE FROM table1 WHERE f1=2}
71 set v [catch {execsql {DELETE FROM table2 WHERE f3=5}} msg]
76 set v [catch {execsql {DELETE FROM table2 WHERE xyzzy(f1+4)}} msg]
84 execsql {DELETE FROM table1}
98 execsql {DELETE FROM table1}
110 execsql {DELETE FROM table1}
125 execsql "DELETE FROM table1 WHERE f1==$i"
130 execsql "DELETE FROM table1 WHERE f1>50"
135 execsql "DELETE FROM table1 WHERE f1==$i"
141 execsql "DELETE FROM table1 WHERE f1==$i"
146 execsql "DELETE FROM table1 WHERE f1!=48"
161 execsql {DELETE FROM table1}
163 execsql {DELETE FROM table2}
178 execsql {DELETE FROM table1 WHERE f1>7}
182 execsql {DELETE FROM table2 WHERE f1>7}
186 execsql {DELETE FROM table1}
194 execsql {DELETE FROM table2}
216 CREATE TRIGGER r1 AFTER DELETE ON t3 FOR EACH ROW BEGIN
219 DELETE FROM t3 WHERE a<2;
230 DELETE FROM t3;
246 DELETE FROM t3;
247 DELETE FROM t4;
268 DELETE FROM t3;
276 DELETE FROM t3 WHERE 1;
284 DELETE FROM t3 WHERE a<100;