CREATE [OR REPLACE] [ALGORITHM = ...]
   VIEW view_name [(column_list)] AS
      select statement
   [WITH [CASCADED | LOCAL] CHECK OPTION]
* ALGORITHM = { UNDEFINED | MERGE | TEMPTABLE }

Example:
CREATE OR REPLACE ALGORITHM = TEMPTABLE 
   VIEW v (coutnryName, cityName) AS
      SELECT Country.Name, City.Name
      FROM Country, City WHERE Country.Code = City.CountryCode;
You might want to specify TEMPTABLE to influence how MySQL uses locking while it process the view.
WITH CHECK OPTION is allowed only for updatable views, and an error occurs if you use it for a non-updatable view.

Restrictions on Views
Can't associate a trigger with a view.
Can't use subqueries in the FROM clause.
Can't use TEMPORARY tables.
Can't use any user variables.

The following statements are for checking views:
CHECK TABLE view_name;
SHOW CREATE VIEW view_name;
SHOW FULL TABLES FROM database_name;
To use the OR REPLACE, ALTER VIEW or DROP VIEW, the DROP privilege is required.
Privileges for a view apply to the view, not to the underlying tables.