Lines Matching refs:FROM

27     SELECT * FROM t1;
34     CREATE VIEW v1 AS SELECT a,b FROM t1;
35     SELECT * FROM v1 ORDER BY a;
41     SELECT * FROM v1 ORDER BY a;
46     CREATE VIEW v1 AS SELECT a,b FROM t1;
47     SELECT * FROM v1 ORDER BY a;
54     SELECT * FROM v1 ORDER BY a;
60     SELECT * FROM v1 ORDER BY a;
65     CREATE VIEW v1 AS SELECT a,b FROM t1;
66     SELECT * FROM v1 ORDER BY a;
72     SELECT * FROM v1 ORDER BY a;
81     SELECT * FROM v1 ORDER BY a;
88     SELECT * FROM v1 ORDER BY a;
94     CREATE VIEW v2 AS SELECT * FROM t1 WHERE a>5
97     SELECT * FROM v2;
112     DELETE FROM v2;
118     SELECT * FROM v2 ORDER BY x;
123     SELECT x FROM v2 WHERE a>10
131     SELECT * FROM v1 LIMIT 1
136     SELECT * FROM v2 LIMIT 1
142     CREATE VIEW v1 AS SELECT a AS 'xyz', b+c AS 'pqr', c-b FROM t1;
143     SELECT * FROM v1 LIMIT 1
148     CREATE VIEW v3 AS SELECT a FROM t1 UNION SELECT b FROM t1 ORDER BY b;
149     SELECT * FROM v3 LIMIT 4;
155       SELECT a, b FROM t1 
157       SELECT b AS 'x', a AS 'y' FROM t1
159     SELECT y FROM v4 ORDER BY y LIMIT 4;
171     SELECT 1 FROM t1 LIMIT 1;
181      SELECT 1 FROM v1 LIMIT 1;
197     SELECT * FROM t2;
203       SELECT t1.x AS v, t2.y AS w FROM t1 JOIN t2 USING(a);
204     SELECT * FROM v5;
212     EXPLAIN SELECT * FROM v5;
217     SELECT * FROM v5 AS a, t2 AS b WHERE a.w=b.y;
222     EXPLAIN SELECT * FROM v5 AS a, t2 AS b WHERE a.w=b.y;
227     SELECT * FROM t2 AS b, v5 AS a WHERE a.w=b.y;
232     EXPLAIN SELECT * FROM t2 AS b, v5 AS a WHERE a.w=b.y;
237     SELECT * FROM t1 AS a, v5 AS b, t2 AS c WHERE a.x=b.v AND b.w=c.y;
242     EXPLAIN SELECT * FROM t1 AS a, v5 AS b, t2 AS c WHERE a.x=b.v AND b.w=c.y;
248     SELECT min(x), min(a), min(b), min(c), min(a+b+c) FROM v2;
253     SELECT max(x), max(a), max(b), max(c), max(a+b+c) FROM v2;
265       FROM test1 JOIN test2 ON test2.id=test1.id;
266     SELECT * FROM test;
273     SELECT * FROM test;
281       FROM test1 JOIN test2 USING(id);
282     SELECT * FROM test;
289     SELECT * FROM test;
297       FROM test1 NATURAL JOIN test2;
298     SELECT * FROM test;
305     SELECT * FROM test;
311     CREATE VIEW v6 AS SELECT pqr, xyz FROM v1;
312     SELECT * FROM v6 ORDER BY xyz;
319     SELECT * FROM v6 ORDER BY xyz;
324     CREATE VIEW v7 AS SELECT pqr+xyz AS a FROM v6;
325     SELECT * FROM v7 ORDER BY a;
330     CREATE VIEW v8 AS SELECT max(cnt) AS mx FROM
331       (SELECT a%2 AS eo, count(*) AS cnt FROM t1 GROUP BY eo);
332     SELECT * FROM v8;
337     SELECT mx+10, mx*2 FROM v8;
342     SELECT mx+10, pqr FROM v6, v8 WHERE xyz=2;
347     SELECT mx+10, pqr FROM v6, v8 WHERE xyz>2;
355     INSERT INTO t2 SELECT * FROM t2 WHERE a<5;
356     INSERT INTO t2 SELECT * FROM t2 WHERE a<4;
357     INSERT INTO t2 SELECT * FROM t2 WHERE a<3;
358     SELECT DISTINCT count(*) FROM t2 GROUP BY a ORDER BY 1;
363     SELECT DISTINCT count(*) FROM t2 GROUP BY a ORDER BY 1 LIMIT 3;
369        SELECT DISTINCT count(*) FROM t2 GROUP BY a ORDER BY 1 LIMIT 3;
370     SELECT * FROM v9;
375     SELECT * FROM v9 ORDER BY 1 DESC;
381        SELECT DISTINCT a, count(*) FROM t2 GROUP BY a ORDER BY 2 LIMIT 3;
382     SELECT * FROM v10;
387     SELECT * FROM v10 ORDER BY 1;
398     CREATE VIEW v_t3_a AS SELECT a.[9] FROM t3 AS a;
399     CREATE VIEW v_t3_b AS SELECT "4" FROM t3;
400     SELECT * FROM v_t3_a;
405     SELECT * FROM v_t3_b;