How do you create view in MySQL?

1.	How do you create view in MySQL?
Answer» In MYSQL, the CREATE VIEW STATEMENT is used to create a new view inside the database. Here’s the basic syntax of the statement: CREATE VIEW productList AS SELECT QTY, price, totalprice AS value FROM PRODUCT;

Answer»

In MYSQL, the CREATE VIEW STATEMENT is used to create a new view inside the database.

Here’s the basic syntax of the statement:

CREATE VIEW productList AS SELECT QTY, price, totalprice AS value FROM PRODUCT;

Discussion