
- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
What are the limitations of using MySQL views?
In spite of various benefits of using views there are following limitations on using MySQL views −
- Can’t create an index of views − In MySQL, we cannot create an index on views. It is because indexes are not utilized when we query data against the views.
- MySQL invalidates the view − Suppose, if we drop or rename tables to which a view references, rather than issuing an error MySQL invalidate the view. We can use the CHECK TABLE statement to check whether the view is valid or not.
- MySQL views cannot be updateable in some situations − Actually, the simple view can be updateable but a view created on a complex SELECT statement with JOIN or SUBQUERY etc. cannot be updateable.
- MySQL does not support materialized views − We cannot create materialized views because MySQL does not support it.
- Using subquery in the FROM clause of view depends on MySQL version − Actually, we can use a subquery in the FROM clause of view if MySQL version is less than 5.7.7.
- Cannot create a TEMPORARY view − Actually, the definition cannot refer to a TEMPORARY table hence we cannot create a TEMPORARY view.
- Cannot associate a trigger with a view − we cannot associate a trigger with a view.
- Related Articles
- What are the limitations of MySQL ENUMs?
- What are the prerequisites before starting writing and using MySQL views?
- What are the benefits of using MySQL views as compared to selecting data directly from MySQL base tables?
- What are the different privileges required for using views?
- What are the limitations of JavaScript?
- What are the limitations of RPA?
- What are the limitations of Python?
- What are the types of Materialized Views?
- What are the limitations of data mining?
- What are the Limitations of Ratio Analysis?
- What Are the Limitations of Digital Marketing?
- What are the limitations of using OUTER JOIN on a DB2 table?
- What Are The Major Limitations Of Blockchain Technology?
- What are the limitations of Rutherford’s model of the atom?
- What are the advantages and limitations of JDBC PreparedStatement?

Advertisements