What are MySQL views and when to use them?

A distinct way of looking at database data is called a VIEW. A VIEW is a virtual table of the result set obtained from a MySQL statement (rows and columns of a vir...

Create views in MySQL

The VIEWS is representation of a data from one or more tables. Data can be extracted from tables using statements like

Modifying views in MySQL

The VIEWS once created can be modified using ALTER s...

Managing views in MySQL

Following operations may be done on VIEWS after creating it: Update View A VIEW can be updated