This is a tutorial from Kogibay Technologies on how to create a view in mysql database.
Syntax for creating View in MySQL :
create view 'view_name_here' AS 'SQL_STATEMENT_HERE';
Example of view in MySQL database is given below by Kogibay Technologies DBMaster
In MySQL editor or console enter the following command to create view in MySQL:
create view select firstname,lastname,memberno from members;