Lines Matching refs:AS
34 CREATE VIEW v1 AS SELECT a,b FROM t1;
46 CREATE VIEW v1 AS SELECT a,b FROM t1;
65 CREATE VIEW v1 AS SELECT a,b FROM t1;
94 CREATE VIEW v2 AS SELECT * FROM t1 WHERE a>5
142 CREATE VIEW v1 AS SELECT a AS 'xyz', b+c AS 'pqr', c-b FROM t1;
148 CREATE VIEW v3 AS SELECT a FROM t1 UNION SELECT b FROM t1 ORDER BY b;
154 CREATE VIEW v4 AS
157 SELECT b AS 'x', a AS 'y' FROM t1
202 CREATE VIEW v5 AS
203 SELECT t1.x AS v, t2.y AS w FROM t1 JOIN t2 USING(a);
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;
263 CREATE VIEW test AS
279 CREATE VIEW test AS
295 CREATE VIEW test AS
311 CREATE VIEW v6 AS SELECT pqr, xyz FROM v1;
324 CREATE VIEW v7 AS SELECT pqr+xyz AS a FROM v6;
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);
368 CREATE VIEW v9 AS
380 CREATE VIEW v10 AS
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;