MySQL Views
This tutorial introduces you to MySQL Views, which are named queries stored in the database, and shows you how to manage views effectively.
MySQL CREATE VIEW
By default, the CREATE VIEW statement creates a view in the current database. If you want to explicitly create a view in a given database, you can qualify the view name with the database …
MySQL DROP VIEW
In this syntax, you specify a list of comma-separated views after the DROP VIEW keywords. If the list contains a view that doesn’t exist, the DROP VIEW statement will fail and won’t delete any …
MySQL Show View
MySQL Show View Summary: in this tutorial, you will learn how to show all views in a MySQL database using the SHOW FULL TABLE statement or by querying information from the data …
MySQL Updatable Views
MySQL views are not only query-able but also updatable. In this tutorial, you will learn how to create updatable views in MySQL.
What is MySQL
MySQL is a robust database management system designed for managing relational databases. It is open-source software supported by Oracle, meaning that you can use MySQL without any …
Understanding MySQL View Processing Algorithms
In this tutorial, you will learn about the MySQL view processing algorithms including MERGE, TEMPTABLE, and UNDEFINED.
An Introduction to MySQL CTE
After you define a CTE, you can use like a view in the SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. The following illustrates the basic syntax of a CTE:
MySQL SHOW CREATE VIEW
In this tutorial, you will learn how to use the MySQL SHOW CREATE VIEW statement to display the statement that creates a view.
MySQL View WITH CHECK OPTION
Sometimes, you create a view to reveal the partial data of a table. However, a simple view is updatable, and therefore, it is possible to update data that is not visible through the view.