How to create VIEW in MySQL?

MySQL Create VIEW

A VIEW is created by SELECT statements. SELECT statements are used to take data from the source table to make a VIEW.

Syntax:
CREATE [OR REPLACE] VIEW view_name AS 
SELECT columns 
FROM tables 
[WHERE conditions]; 
Parameters:
OR REPLACE: It is optional. It is used when a VIEW already exist. If you do not specify this clause and the VIEW already exists, the CREATE VIEW statement will return an error.
view_name: It specifies the name of the VIEW that you want to create in MySQL.
WHERE conditions: It is also optional. It specifies the conditions that must be met for the records to be included in the VIEW.
The following example will create a VIEW name "trainer". This is a virtual table made by taking data from the table "courses".

CREATE VIEW trainer AS 
SELECT course_name, course_trainer 
 FROM courses; 
To see the created VIEW:
Syntax:
SELECT * FROM view_name; 
Let's see how it looks the created VIEW:
SELECT * FROM trainer;

Subscribe channel on YouTube
Read this post on Blogger
Like page on Facebook
Tweet about video on twitter
Let's chat on whatsapp
See you at Instagram