MySQL View

MySQL Tutorial

MySQL-Home MySQL-Environment setup MySQL- Workbench MySQL-Basic syntax MySQL-Operator MySQL-Data type MySQL-Comments MySQL-Create DB MySQL-Drop DB MySQL-Select DB MySQL-Create Table MySQL-Drop table MySQL-Truncate MySQL-Primary Key MySQL-Foreign Key MySQL-Null MySQL-Increment MySQL-Having MySQL-Top MySQL-Insert Statement MySQL-Select Statement MySQL-Alter Statement MySQL-Where MySQL-And & Or MySQL-Default values MySQL-Exists MySQL-Order by MySQL-View MySQL-Update Statement MySQL-Delete Statement MySQL-Like MySQL-Sort MySQL-Limit MySQL-Min MySQL-Max MySQL-Group MySQL-In MySQL-Between MySQL-Union MySQL-Count MySQL-Average MySQL-Sum MySQL-Date & Time MySQL-Import MySQL-Export MySQL-Index MySQL-Temporary MySQL-Join MySQL-Full Join MySQL-Inner Join MySQL-Left Join MySQL-Right Join MySQL-Store Procedure MySQL-Injection MySQL-PHP connection

« Previous Next »

A view is a virtual table based on the result-set of an MySQL statement.

A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.

A view summarize data from various tables can be used to generate reports.

You can add MySQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.


CREATE VIEW view_name AS
SELECT column1, column2, ...
FROM table_name
WHERE condition;

Let's perform the view operation on a database table.

Consider we've an Students table in our database with the following records:

The following MySQL creates a view that shows all Students learn 'JAVA':


CREATE VIEW javastudents AS
SELECT ROLL_NO, NAME,SUBJECT
FROM Students
WHERE SUBJECT = 'JAVA';

Now, you can query [javastudents] in a similar way as you query an actual table.


 SELECT * FROM javastudents;

This would produce the following result.

A view always shows up-to-date data! The database engine recreates the data, using the view's MySQL statement, every time a user queries a view.

« Previous Next »

MySQL - View