How do you create and execute views in MySQL?

1.	How do you create and execute views in MySQL?
Answer» Creating a view is accomplished with the CREATE VIEW STATEMENT. As an example: CREATE [OR REPLACE] [ALGORITHM = {MERGE \| TEMPTABLE \| UNDEFINED }] [DEFINER = { user \| CURRENT_USER }] [SQL SECURITY { DEFINER \| INVOKER }] VIEW view_name [(column_list)] AS select_statement [WITH [CASCADED \| LOCAL] CHECK OPTION]

Discussion