Lines Matching refs:INSERT
13 # focus of this file is testing the INSERT statement.
23 set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3)}} msg]
30 set v [catch {execsql {INSERT INTO sqlite_master VALUES(1,2,3,4)}} msg]
38 set v [catch {execsql {INSERT INTO test1 VALUES(1,2)}} msg]
42 set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3,4)}} msg]
46 set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1,2,3,4)}} msg]
50 set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1)}} msg]
57 set v [catch {execsql {INSERT INTO test1(one,four) VALUES(1,2)}} msg]
64 execsql {INSERT INTO test1 VALUES(1,2,3)}
68 execsql {INSERT INTO test1 VALUES(4,5,6)}
72 execsql {INSERT INTO test1 VALUES(7,8,9)}
78 execsql {INSERT INTO test1(one,two) VALUES(1,2)}
82 execsql {INSERT INTO test1(two,three) VALUES(5,6)}
86 execsql {INSERT INTO test1(three,one) VALUES(7,8)}
104 execsql {INSERT INTO test2(f1,f3) VALUES(+10,-10)}
108 execsql {INSERT INTO test2(f2,f4) VALUES(1.23,-3.45)}
112 execsql {INSERT INTO test2(f1,f2,f4) VALUES(77,+1.23,3.45)}
129 execsql {INSERT INTO test2(f2,f4) VALUES(-2.22,'hi!')}
133 execsql {INSERT INTO test2(f1,f5) VALUES(1,'xyzzy')}
150 execsql {INSERT INTO test2(f2,f4) VALUES(-3.33,'hum')}
154 execsql {INSERT INTO test2(f1,f2,f5) VALUES(22,-4.44,'wham')}
167 INSERT INTO t3 VALUES(1+2+3,4,5);
173 INSERT INTO t3 VALUES((SELECT max(a) FROM t3)+1,5,6);
179 INSERT INTO t3 VALUES((SELECT max(a) FROM t3)+1,t3.a,6);
185 INSERT INTO t3 VALUES((SELECT b FROM t3 WHERE a=0),6,7);
196 INSERT INTO t3 VALUES(notafunc(2,3),2,3);
201 INSERT INTO t3 VALUES(min(1,2,3),max(1,2,3),99);
212 INSERT INTO t4 VALUES(1);
218 INSERT INTO t4 SELECT x+1 FROM t4;
225 EXPLAIN INSERT INTO t4 SELECT x+2 FROM t4;
245 INSERT INTO t4 SELECT one FROM test1 WHERE three=7;
252 EXPLAIN INSERT INTO t4 SELECT one FROM test1;
262 INSERT INTO t1 VALUES(1,2);
263 INSERT INTO t1 VALUES(2,3);