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;

Suggest An Answer

No suggestions Available!