Del sitio de mysql:
Chapter 21. Views
Table of Contents
21.1. ALTER VIEW Syntax
21.2. CREATE VIEW Syntax
21.3. DROP VIEW Syntax
21.4. SHOW CREATE VIEW Syntax
Views (including updatable views) are implemented in the 5.0 version of MySQL Server. Views are available in binary releases from 5.0.1 and up.
This chapter discusses the following topics:
*
Creating or altering views with CREATE VIEW or ALTER VIEW
*
Destroying views with DROP VIEW
*
Displaying view metadata with SHOW CREATE VIEW
Discussion of restrictions on use of views is given in Appendix H, MySQL Feature Restrictions.
To use views if you have upgraded to MySQL 5.0.1 from an older release, you should upgrade your grant tables so that they contain the view-related privileges. See Section 2.10.7, “Upgrading the Grant Tables”.
http://dev.mysql.com/doc/mysql/en/views.html