View in MySql

View is a virtual table which does not have it's own data, it's derived it's data from other table called Underline or Base table.

We can create view on a table or another views.

Syntax of the view is:-

CREATE VIEW VIEW_NAME AS SELECT STATEMENT;

Below is example :-

CREATE VIEW VW_EMP AS SELECT  EMP_ID,EMP_NAME FROM EMPLOYEE;





Read Also:-  Create view in Oracle