Lines Matching refs:DELETE

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]
47   execsql {DELETE FROM table1 WHERE f1=3}
55   execsql {DELETE FROM 'table1' WHERE f1=3}
61   execsql {DELETE FROM table1 WHERE f1=2}
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}
100   execsql {DELETE FROM table1}
112   execsql {DELETE FROM table1}
127      execsql "DELETE FROM table1 WHERE f1==$i"
132   execsql "DELETE FROM table1 WHERE f1>50"
137      execsql "DELETE FROM table1 WHERE f1==$i"
143      execsql "DELETE FROM table1 WHERE f1==$i"
148   execsql "DELETE FROM table1 WHERE f1!=48"
163   execsql {DELETE FROM table1}
165   execsql {DELETE FROM table2}
180   execsql {DELETE FROM table1 WHERE f1>7}
184   execsql {DELETE FROM table2 WHERE f1>7}
188   execsql {DELETE FROM table1}
196   execsql {DELETE FROM table2}
218     CREATE TRIGGER r1 AFTER DELETE ON t3 FOR EACH ROW BEGIN
221     DELETE FROM t3 WHERE a<2;
232     DELETE FROM t3;
248     DELETE FROM t3;
249     DELETE FROM t4;
270     DELETE FROM t3;
278     DELETE FROM t3 WHERE 1;
286     DELETE FROM t3 WHERE a<100;