Lines Matching refs:t1
41 CREATE TABLE t1(a,b,c);
44 INSERT INTO t1 VALUES(1,2,3);
45 INSERT INTO t1 VALUES(4,5,6);
47 SELECT * FROM t1;
49 INSERT INTO t1 VALUES(1,2,3);
50 INSERT INTO t1 VALUES(4,5,6);
52 SELECT * FROM t1;
53 DELETE FROM t1 WHERE a<100;
85 CREATE TABLE t1(a, b, c);
86 INSERT INTO t1 VALUES(1, randstr(5,50), randstr(5,50));
87 INSERT INTO t1 SELECT a+2, b||'-'||rowid, c||'-'||rowid FROM t1;
88 INSERT INTO t1 SELECT a+4, b||'-'||rowid, c||'-'||rowid FROM t1;
89 INSERT INTO t1 SELECT a+8, b||'-'||rowid, c||'-'||rowid FROM t1;
90 INSERT INTO t1 SELECT a+16, b||'-'||rowid, c||'-'||rowid FROM t1;
91 INSERT INTO t1 SELECT a+32, b||'-'||rowid, c||'-'||rowid FROM t1;
92 INSERT INTO t1 SELECT a+64, b||'-'||rowid, c||'-'||rowid FROM t1;
93 INSERT INTO t1 SELECT a+128, b||'-'||rowid, c||'-'||rowid FROM t1;
94 CREATE TABLE t2 AS SELECT * FROM t1;
95 CREATE TABLE t3 AS SELECT * FROM t1;
103 } {t1 t3}