D.S

dev.mysql.com

MySQL :: MySQL 5.7 Reference Manual :: A.6 MySQL 5.7 FAQ: Views

MySQL :: MySQL 5.7 Reference Manual :: A.6 MySQL 5.7 FAQ: Views Contact MySQL  |  Login  |  Register The world's most popular open source database MySQL.com Downloads Documentation Developer Zone Developer Zone Downloads MySQL.com Documentation MySQL Server MySQL Enterprise Workbench Router Utilities/Fabric MySQL NDB Cluster Connectors More MySQL.com Downloads Developer Zone Section Menu:   Documentation Home MySQL 5.7 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Using MySQL as a Document Store Tutorial MySQL Programs MySQL Server Administration Security Backup and Recovery Optimization Language Structure Globalization Data Types Functions and Operators SQL Statement Syntax The InnoDB Storage Engine Alternative Storage Engines High Availability and Scalability Replication MySQL NDB Cluster 7.5 Partitioning Stored Programs and Views INFORMATION_SCHEMA Tables MySQL Performance Schema MySQL sys Schema Connectors and APIs Extending MySQL MySQL Enterprise Edition MySQL Workbench MySQL 5.7 Frequently Asked Questions MySQL 5.7 FAQ: General MySQL 5.7 FAQ: Storage Engines MySQL 5.7 FAQ: Server SQL Mode MySQL 5.7 FAQ: Stored Procedures and Functions MySQL 5.7 FAQ: Triggers MySQL 5.7 FAQ: Views MySQL 5.7 FAQ: INFORMATION_SCHEMA MySQL 5.7 FAQ: Migration MySQL 5.7 FAQ: Security MySQL 5.7 FAQ: MySQL Cluster MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets MySQL 5.7 FAQ: Connectors & APIs MySQL 5.7 FAQ: Replication MySQL 5.7 FAQ: MySQL Enterprise Thread Pool MySQL 5.7 FAQ: InnoDB Change Buffer MySQL 5.7 FAQ: InnoDB Tablespace Encryption MySQL 5.7 FAQ: Virtualization Support Errors, Error Codes, and Common Problems Restrictions and Limits Indexes MySQL Glossary Related Documentation MySQL 5.7 Release Notes Download this Manual PDF (US Ltr) - 35.7Mb PDF (A4) - 35.7Mb PDF (RPM) - 34.7Mb EPUB - 8.7Mb HTML Download (TGZ) - 8.5Mb HTML Download (Zip) - 8.5Mb HTML Download (RPM) - 7.3Mb Eclipse Doc Plugin (TGZ) - 9.3Mb Eclipse Doc Plugin (Zip) - 11.5Mb Man Pages (TGZ) - 203.5Kb Man Pages (Zip) - 308.9Kb Info (Gzip) - 3.3Mb Info (Zip) - 3.3Mb Excerpts from this Manual MySQL Backup and Recovery MySQL Globalization MySQL Information Schema MySQL Installation Guide MySQL and Linux/Unix MySQL and OS X MySQL Partitioning MySQL Performance Schema MySQL Replication Using the MySQL Yum Repository MySQL Restrictions and Limitations Security in MySQL MySQL and Solaris Building MySQL from Source Starting and Stopping MySQL MySQL Tutorial MySQL and Windows MySQL Cluster NDB 7.5 version 5.7 8.0 5.6 5.5 5.6  Japanese MySQL 5.7 Reference Manual  /  MySQL 5.7 Frequently Asked Questions  /  MySQL 5.7 FAQ: Views A.6 MySQL 5.7 FAQ: Views A.6.1. Where can I find documentation covering MySQL Views? A.6.2. Is there a discussion forum for MySQL Views? A.6.3. What happens to a view if an underlying table is dropped or renamed? A.6.4. Does MySQL 5.7 have table snapshots? A.6.5. Does MySQL 5.7 have materialized views? A.6.6. Can you insert into views that are based on joins? A.6.1. Where can I find documentation covering MySQL Views? See Section 21.5, “Using Views” . A.6.2. Is there a discussion forum for MySQL Views? Yes. See http://forums.mysql.com/list.php?100 A.6.3. What happens to a view if an underlying table is dropped or renamed? After a view has been created, it is possible to drop or alter a table or view to which the definition refers. To check a view definition for problems of this kind, use the CHECK TABLE statement. (See Section 14.7.2.2, “CHECK TABLE Syntax” .) A.6.4. Does MySQL 5.7 have table snapshots? No. A.6.5. Does MySQL 5.7 have materialized views? No. A.6.6. Can you insert into views that are based on joins? It is possible, provided that your INSERT statement has a column list that makes it clear there is only one table involved. You cannot insert into multiple tables with a single insert on a view. PREV   HOME   UP   NEXT Related Documentation MySQL 5.7 Release Notes Download this Manual PDF (US Ltr) - 35.7Mb PDF (A4) - 35.7Mb PDF (RPM) - 34.7Mb EPUB - 8.7Mb HTML Download (TGZ) - 8.5Mb HTML Download (Zip) - 8.5Mb HTML Download (RPM) - 7.3Mb Eclipse Doc Plugin (TGZ) - 9.3Mb Eclipse Doc Plugin (Zip) - 11.5Mb Man Pages (TGZ) - 203.5Kb Man Pages (Zip) - 308.9Kb Info (Gzip) - 3.3Mb Info (Zip) - 3.3Mb Excerpts from this Manual MySQL Backup and Recovery MySQL Globalization MySQL Information Schema MySQL Installation Guide MySQL and Linux/Unix MySQL and OS X MySQL Partitioning MySQL Performance Schema MySQL Replication Using the MySQL Yum Repository MySQL Restrictions and Limitations Security in MySQL MySQL and Solaris Building MySQL from Source Starting and Stopping MySQL MySQL Tutorial MySQL and Windows MySQL Cluster NDB 7.5 User Comments Sign Up Login You must be logged in to post a comment. Contact Sales USA: +1-866-221-0634 Canada: +1-866-221-0634 Germany: +49 89 143 01280 France: +33 1 57 60 83 57 Italy: +39 02 249 59 120 UK: +44 207 553 8447 Japan: 0120-065556 China: 10