Chapter 19. Views

Table of Contents

19.1. ALTER VIEW Syntax
19.2. CREATE VIEW Syntax
19.3. DROP VIEW Syntax

Views (including updatable views) are implemented in MySQL Server 5.0. Views are available in binary releases from 5.0.1 and up.

This chapter discusses the following topics:

Discussion of restrictions on use of views is given in Section I.4, “Restrictions on Views”.

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 5.6.2, “mysql_upgrade — Check Tables for MySQL Upgrade”.

Metadata about views can be obtained from the INFORMATION_SCHEMA.VIEWS table and by using the SHOW CREATE VIEW statement. See Section 20.15, “The INFORMATION_SCHEMA VIEWS Table”, and Section, “SHOW CREATE VIEW Syntax”.

19.1. ALTER VIEW Syntax

    [DEFINER = { user | CURRENT_USER }]
    VIEW view_name [(column_list)]
    AS select_statement

This statement changes the definition of an existing view. The syntax is similar to that for CREATE VIEW. See Section 19.2, “CREATE VIEW Syntax”. This statement requires the CREATE VIEW and DROP privileges for the view, and some privilege for each column referred to in the SELECT statement.

This statement was added in MySQL 5.0.1. The DEFINER and SQL SECURITY clauses may be used as of MySQL 5.0.16 to specify the security context to be used when checking access privileges at view invocation time. For details, see Section 19.2, “CREATE VIEW Syntax”.