MySQL CREATE VIEW Statement

In relational database management systems (RDBMS) like MySQL, a view is a virtual table interactive with data generated from one or more underlying tables through either a defined query. Unlike a regular table, the view as a query doesn’t store the data itself. Instead, it creates a result set when someone queries it. The VIEWS are created using SELECT queries.

Syntax:

CREATE VIEW view_name AS

SELECT column1, column2, . . . . column_n

FROM table_name

WHERE condition1, condition2, . . . . , condition_n;

Explanation: In the above syntax you can see that we are creating a VIEW using the CREATE VIEW statement. The VIEW contains the selected columns from the table. WHERE condition can be specified or not it is not necessary.