Updated on 2022-09-15 GMT+08:00

CREATE VIEW

Syntax

CREATE VIEW [IF NOT EXISTS] view_name
  [{columnName [, columnName ]* }] [COMMENT view_comment]
  AS query_expression

Function

Create a view with multiple layers nested in it to simplify the development process.

Description

IF NOT EXISTS

If the view already exists, nothing happens.

Example

Create a view named viewName.

create view viewName as select * from dataSource