Lines Matching refs:t5
133 CREATE TABLE t5(x,y);
134 INSERT INTO t5 SELECT x-y, x+y FROM t1 WHERE x BETWEEN 10 AND 15
136 SELECT * FROM t5 ORDER BY x;
141 DELETE FROM t5;
142 INSERT INTO t5 SELECT x-y, x+y FROM t1 WHERE x BETWEEN 10 AND 15
144 SELECT * FROM t5 ORDER BY x;
149 DELETE FROM t5;
150 INSERT INTO t5 SELECT x-y, x+y FROM t1 WHERE x ORDER BY x DESC LIMIT 31;
151 SELECT * FROM t5 ORDER BY x LIMIT 2;
156 SELECT * FROM t5 ORDER BY x DESC, y DESC LIMIT 2;
161 DELETE FROM t5;
162 INSERT INTO t5 SELECT a.x*100+b.x, a.y*100+b.y FROM t1 AS a, t1 AS b
164 SELECT count(*), sum(x), sum(y), min(x), max(x), min(y), max(y) FROM t5;