Lines Matching refs:t1
21 CREATE TABLE t1(a, b, c);
22 INSERT INTO t1 VALUES(1, 2, 3);
25 INSERT INTO t1 VALUES(4, 5, 6);
27 DELETE FROM t1;
34 CREATE TABLE t1(a, b, c);
35 INSERT INTO t1 VALUES(randstr(400,400), randstr(400,400), randstr(400,400));
36 INSERT INTO t1 SELECT
37 randstr(400,400), randstr(400,400), randstr(400,400) FROM t1;
38 INSERT INTO t1
39 SELECT randstr(400,400), randstr(400,400), randstr(400,400) FROM t1;
40 INSERT INTO t1
41 SELECT randstr(400,400), randstr(400,400), randstr(400,400) FROM t1;
42 INSERT INTO t1
43 SELECT randstr(400,400), randstr(400,400), randstr(400,400) FROM t1;
44 INSERT INTO t1
45 SELECT randstr(400,400), randstr(400,400), randstr(400,400) FROM t1;
46 INSERT INTO t1
47 SELECT randstr(400,400), randstr(400,400), randstr(400,400) FROM t1;
48 INSERT INTO t1
49 SELECT randstr(400,400), randstr(400,400), randstr(400,400) FROM t1;
50 INSERT INTO t1
51 SELECT randstr(400,400), randstr(400,400), randstr(400,400) FROM t1;
55 DELETE FROM t1 WHERE rowid < 5;
57 DELETE FROM t1 WHERE rowid > 10;
64 CREATE TABLE t1(a, b, c);
65 INSERT INTO t1 VALUES(1, randstr(1000,1000), randstr(1000,1000));
66 INSERT INTO t1 VALUES(2, randstr(1000,1000), randstr(1000,1000));
69 UPDATE t1 SET a = 3 WHERE a = 1;
71 UPDATE t1 SET a = 4 WHERE a = 2;
85 # CREATE TABLE t1(a, b);
86 # CREATE INDEX i1 ON t1(a);
87 # CREATE INDEX i2 ON t1(b);
88 # INSERT INTO t1 VALUES(randstr(500,500), randstr(500,500)); -- 1
89 # INSERT INTO t1 VALUES(randstr(500,500), randstr(500,500)); -- 2
90 # INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 4
91 # INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 8
92 # INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 16
93 # INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 32
94 # INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 64
95 # INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 128
96 # INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 256
97 # INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 512
98 # INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 1024
99 # INSERT INTO t1 SELECT randstr(500,500), randstr(500,500) FROM t1; -- 2048
103 # UPDATE t1 SET a = randstr(500,500);
115 CREATE TABLE t1(a, b);
118 INSERT INTO t1 VALUES(1, randstr(500,500));
119 INSERT INTO t1 VALUES(2, randstr(500,500));
120 INSERT INTO t1 VALUES(3, randstr(500,500));
121 DELETE FROM t1;
124 INSERT INTO t1 VALUES(1, randstr(500,500));
125 INSERT INTO t1 VALUES(2, randstr(500,500));
126 INSERT INTO t1 VALUES(3, randstr(500,500));