- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- Preface
- 1 General Information
- 2 Installing and Upgrading MySQL
- 3 Tutorial
- 4 MySQL Programs
- 5 MySQL Server Administration
- 6 Backup and Recovery
- 7 Optimization
- 8 Language Structure
- 9 Internationalization and Localization
- 10 Data Types
- 11 Functions and Operators
- 12 SQL Statement Syntax
- 13 Storage Engines
- 14 High Availability and Scalability
- 15 MySQL and Virtualization
- 16 MySQL Load Balancer
- 17 Replication
- 18 MySQL Cluster
- 19 Partitioning
- 20 Spatial Extensions
- 21 Stored Procedures and Functions
- 22 Triggers
- 23 Event Scheduler
- 24 Views
- 25 INFORMATION_SCHEMA Tables
- 26 Precision Math
- 27 APIs and Libraries
- 28 Connectors
- 29 MySQL Proxy
- 30 Extending MySQL
- A MySQL 5.1 Frequently Asked Questions
- B Errors, Error Codes, and Common Problems
- C MySQL Change History
- D Restrictions and Limits
- E Credits
- Index
Table of Contents [+/-]
Views (including updatable views) are available in MySQL Server 5.1.
Answers to some frequently asked questions concerning views in MySQL 5.1 can be found in Section A.6, “MySQL 5.1 FAQ — Views”.
This chapter discusses the following topics:
Creating or altering views with
CREATE VIEWorALTER VIEWDestroying views with
DROP VIEW
Discussion of restrictions on use of views is given in Section D.4, “Restrictions on Views”.
To use views if you have upgraded to MySQL 5.1 from an older release that did not support views, you should upgrade your grant tables so that they contain the view-related privileges. See Section 4.4.8, “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 25.15, “The INFORMATION_SCHEMA VIEWS Table”, and
Section 12.5.4.11, “SHOW CREATE VIEW Syntax”.
User Comments
Add your own comment.