File: parseCreateViewAsWithAs.in

package info (click to toggle)
phpmyadmin-sql-parser 5.10.3-1~bpo12%2B1
  • links: PTS, VCS
  • area: main
  • in suites: bookworm-backports
  • size: 16,868 kB
  • sloc: php: 52,916; makefile: 13; sh: 8
file content (25 lines) | stat: -rw-r--r-- 388 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
 
-- create first view
CREATE VIEW withclause AS

WITH cte AS (
  SELECT p.name, p.shape
  FROM gis_all as p
)

SELECT cte.*
FROM cte
CROSS JOIN gis_all;
-- create second view
CREATE VIEW withclause2 AS

WITH cte AS (
  SELECT p.name, p.shape
  FROM gis_all as p
), cte2 AS (
  SELECT p.name as n2, p.shape as sh2
  FROM gis_all as p
)

SELECT cte.*,cte2.*
FROM cte,cte2
CROSS JOIN gis_all;