Lines Matching refs:INSERT

30     INSERT INTO t1
37     INSERT INTO t1 VALUES(2,'x');
54     INSERT INTO t1
56     INSERT INTO t1 SELECT a+1, b||b FROM t1;
57     INSERT INTO t1 SELECT a+2, b||b FROM t1;
58     INSERT INTO t1 SELECT a+4, b FROM t1;
59     INSERT INTO t1 SELECT a+8, b FROM t1;
60     INSERT INTO t1 SELECT a+16, b FROM t1;
61     INSERT INTO t1 SELECT a+32, b FROM t1;
62     INSERT INTO t1 SELECT a+64, b FROM t1;
68     INSERT INTO t1 VALUES(200,'hello out there');
118     INSERT INTO t2 VALUES(2147483648);
124     INSERT INTO t2 VALUES(-2147483649);
130     INSERT INTO t2 VALUES(+2147483649);
136     INSERT INTO t2 VALUES(+2147483647);
137     INSERT INTO t2 VALUES(-2147483648);
138     INSERT INTO t2 VALUES(-2147483647);
139     INSERT INTO t2 VALUES(2147483646);
190     INSERT INTO t3(b) VALUES('abc');
191     INSERT INTO t3(b) VALUES('xyz');
192     INSERT INTO t3(b) VALUES(NULL);
193     INSERT INTO t3(b) VALUES(NULL);
194     INSERT INTO t3(b) SELECT b||'d' FROM t3;
195     INSERT INTO t3(b) SELECT b||'e' FROM t3;
196     INSERT INTO t3(b) SELECT b||'f' FROM t3;
197     INSERT INTO t3(b) SELECT b||'g' FROM t3;
198     INSERT INTO t3(b) SELECT b||'h' FROM t3;
219     INSERT INTO x1 VALUES('dog',3);
220     INSERT INTO x1 VALUES('cat',1);
221     INSERT INTO x1 VALUES('dog',4);
223     INSERT INTO x2 VALUES(1,'one');
224     INSERT INTO x2 VALUES(2,'two');
225     INSERT INTO x2 VALUES(3,'three');
226     INSERT INTO x2 VALUES(4,'four');
267       INSERT INTO y3(c) SELECT b FROM y2 ORDER BY b LIMIT 1;
269     INSERT INTO y1 VALUES(1);
270     INSERT INTO y1 VALUES(2);
271     INSERT INTO y1 SELECT a+2 FROM y1;
272     INSERT INTO y1 SELECT a+4 FROM y1;
273     INSERT INTO y1 SELECT a+8 FROM y1;
274     INSERT INTO y1 SELECT a+16 FROM y1;
275     INSERT INTO y2 SELECT a FROM y1;