How do you create and execute views in MySQL?

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]

you can use create view command ,example

mysql> create view books_view as select * from books;
Query OK, 0 rows affected (0.01 sec)