limited time offer

What is view in MYSQL ?

VIEWS are virtual tables. By virtual, we mean, the tables do not store any data of their own but display data stored in other tables. In other words, VIEWS are nothing but SELECT Queries.

Syntax to create view Statement

CREATE VIEW 'view_name' AS SELECT statement;

Syntax to See the Created View

SELECT * FROM view_name;  

Syntax to Modify/Update Existing View

ALTER VIEW view_name AS  
SELECT columns  
FROM table  
WHERE conditions;  

Syntax to Delete Existing View

DROP VIEW view_name;