Lines Matching refs:AS
32 CREATE VIEW v1 AS SELECT a,b FROM t1;
44 CREATE VIEW v1 AS SELECT a,b FROM t1;
63 CREATE VIEW v1 AS SELECT a,b FROM t1;
92 CREATE VIEW v2 AS SELECT * FROM t1 WHERE a>5
140 CREATE VIEW v1 AS SELECT a AS 'xyz', b+c AS 'pqr', c-b FROM t1;
146 CREATE VIEW v3 AS SELECT a FROM t1 UNION SELECT b FROM t1 ORDER BY b;
152 CREATE VIEW v4 AS
155 SELECT b AS 'x', a AS 'y' FROM t1
200 CREATE VIEW v5 AS
201 SELECT t1.x AS v, t2.y AS w FROM t1 JOIN t2 USING(a);
215 SELECT * FROM v5 AS a, t2 AS b WHERE a.w=b.y;
220 EXPLAIN SELECT * FROM v5 AS a, t2 AS b WHERE a.w=b.y;
225 SELECT * FROM t2 AS b, v5 AS a WHERE a.w=b.y;
230 EXPLAIN SELECT * FROM t2 AS b, v5 AS a WHERE a.w=b.y;
235 SELECT * FROM t1 AS a, v5 AS b, t2 AS c WHERE a.x=b.v AND b.w=c.y;
240 EXPLAIN SELECT * FROM t1 AS a, v5 AS b, t2 AS c WHERE a.x=b.v AND b.w=c.y;
261 CREATE VIEW test AS
277 CREATE VIEW test AS
293 CREATE VIEW test AS
309 CREATE VIEW v6 AS SELECT pqr, xyz FROM v1;
322 CREATE VIEW v7 AS SELECT pqr+xyz AS a FROM v6;
328 CREATE VIEW v8 AS SELECT max(cnt) AS mx FROM
329 (SELECT a%2 AS eo, count(*) AS cnt FROM t1 GROUP BY eo);
366 CREATE VIEW v9 AS
378 CREATE VIEW v10 AS
396 CREATE VIEW v_t3_a AS SELECT a.[9] FROM t3 AS a;
397 CREATE VIEW v_t3_b AS SELECT "4" FROM t3;