Lines Matching refs:VALUES

25   set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3)}} msg]
32   set v [catch {execsql {INSERT INTO sqlite_master VALUES(1,2,3,4)}} msg]
40   set v [catch {execsql {INSERT INTO test1 VALUES(1,2)}} msg]
44   set v [catch {execsql {INSERT INTO test1 VALUES(1,2,3,4)}} msg]
48   set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1,2,3,4)}} msg]
52   set v [catch {execsql {INSERT INTO test1(one,two) VALUES(1)}} msg]
59   set v [catch {execsql {INSERT INTO test1(one,four) VALUES(1,2)}} msg]
66   execsql {INSERT INTO test1 VALUES(1,2,3)}
70   execsql {INSERT INTO test1 VALUES(4,5,6)}
74   execsql {INSERT INTO test1 VALUES(7,8,9)}
80   execsql {INSERT INTO test1(one,two) VALUES(1,2)}
84   execsql {INSERT INTO test1(two,three) VALUES(5,6)}
88   execsql {INSERT INTO test1(three,one) VALUES(7,8)}
106   execsql {INSERT INTO test2(f1,f3) VALUES(+10,-10)}
110   execsql {INSERT INTO test2(f2,f4) VALUES(1.23,-3.45)}
114   execsql {INSERT INTO test2(f1,f2,f4) VALUES(77,+1.23,3.45)}
131   execsql {INSERT INTO test2(f2,f4) VALUES(-2.22,'hi!')}
135   execsql {INSERT INTO test2(f1,f5) VALUES(1,'xyzzy')}
152   execsql {INSERT INTO test2(f2,f4) VALUES(-3.33,'hum')}
156   execsql {INSERT INTO test2(f1,f2,f5) VALUES(22,-4.44,'wham')}
164 # Test of expressions in the VALUES clause
169     INSERT INTO t3 VALUES(1+2+3,4,5);
175     INSERT INTO t3 VALUES((SELECT max(a) FROM t3)+1,5,6);
181     INSERT INTO t3 VALUES((SELECT max(a) FROM t3)+1,t3.a,6);
187     INSERT INTO t3 VALUES((SELECT b FROM t3 WHERE a=0),6,7);
198     INSERT INTO t3 VALUES(notafunc(2,3),2,3);
203     INSERT INTO t3 VALUES(min(1,2,3),max(1,2,3),99);
214     INSERT INTO t4 VALUES(1);
264     INSERT INTO t1 VALUES(1,2);
265     INSERT INTO t1 VALUES(2,3);
271     REPLACE INTO t1 VALUES(1,4);