Lines Matching refs:t5
135 CREATE TABLE t5(x,y);
136 INSERT INTO t5 SELECT x-y, x+y FROM t1 WHERE x BETWEEN 10 AND 15
138 SELECT * FROM t5 ORDER BY x;
143 DELETE FROM t5;
144 INSERT INTO t5 SELECT x-y, x+y FROM t1 WHERE x BETWEEN 10 AND 15
146 SELECT * FROM t5 ORDER BY x;
151 DELETE FROM t5;
152 INSERT INTO t5 SELECT x-y, x+y FROM t1 WHERE x ORDER BY x DESC LIMIT 31;
153 SELECT * FROM t5 ORDER BY x LIMIT 2;
158 SELECT * FROM t5 ORDER BY x DESC, y DESC LIMIT 2;
163 DELETE FROM t5;
164 INSERT INTO t5 SELECT a.x*100+b.x, a.y*100+b.y FROM t1 AS a, t1 AS b
166 SELECT count(*), sum(x), sum(y), min(x), max(x), min(y), max(y) FROM t5;