MySQL Crash Course

CREATE VIEW

CREATE VIEW is used to create a new view of one or more tables. See Chapter 22, "Using Views," for more information.

• Input

CREATE [OR REPLACE] VIEW viewname AS SELECT ...;