A database view is known as a “virtual table” that allows you to query the data in it. Understanding database view and using it correctly are very important. In this section, we will discuss about the database view, how it is implemented in MySQL and how to use it more effectively.
Introduction to Database View
In this tutorial, you will learn about a new database object called database view. We will discuss about the advantages and disadvantages of using database views.
Views in MySQL
In this tutorial, you are going to learn about MySQL View. We will explain how MySQL implements views.
Creating Views in MySQL
This tutorial shows you how to create view in MySQL by using CREATE VIEW statement.
Creating Updateable Views
Views are not only query-able but also updateable. In this tutorial, you will learn how to create updateable views.
Managing Views in MySQL
This tutorial shows you how to manage views in MySQL including displaying, modifying and removing views.