Lines Matching refs:t1
39 CREATE TABLE t1(a,b,c);
42 INSERT INTO t1 VALUES(1,2,3);
43 INSERT INTO t1 VALUES(4,5,6);
45 SELECT * FROM t1;
47 INSERT INTO t1 VALUES(1,2,3);
48 INSERT INTO t1 VALUES(4,5,6);
50 SELECT * FROM t1;
51 DELETE FROM t1 WHERE a<100;
83 CREATE TABLE t1(a, b, c);
84 INSERT INTO t1 VALUES(1, randstr(5,50), randstr(5,50));
85 INSERT INTO t1 SELECT a+2, b||'-'||rowid, c||'-'||rowid FROM t1;
86 INSERT INTO t1 SELECT a+4, b||'-'||rowid, c||'-'||rowid FROM t1;
87 INSERT INTO t1 SELECT a+8, b||'-'||rowid, c||'-'||rowid FROM t1;
88 INSERT INTO t1 SELECT a+16, b||'-'||rowid, c||'-'||rowid FROM t1;
89 INSERT INTO t1 SELECT a+32, b||'-'||rowid, c||'-'||rowid FROM t1;
90 INSERT INTO t1 SELECT a+64, b||'-'||rowid, c||'-'||rowid FROM t1;
91 INSERT INTO t1 SELECT a+128, b||'-'||rowid, c||'-'||rowid FROM t1;
92 CREATE TABLE t2 AS SELECT * FROM t1;
93 CREATE TABLE t3 AS SELECT * FROM t1;
101 } {t1 t3}