MySQL: CREATE VIEW Statement

A VIEW creation in MySQL is sort of like a virtual table derived from a query. You can think of it as aliasing a whole query with a custom table name to make it display with a single query instead of doing the same conditions all over again.

Using CREATE VIEW a virtual view of the query is created in an instance.

Syntax

CREATE VIEW AS View_Name Our Query For The View;

Example

Let us see it in action

select office_id, city from offices where city like 'N%';

• So this query gets the City name which starts with the letter N as you can see clearly from the query.
• Now let us create a view for this.

create view idCity as select office_id, city from offices where city like 'N%';

Here I have created idCity view for the whole query which can then be called upon to be displayed.

As we can see it is a sort of aliasing method for the whole query we write just for the sake of convenience to write the query more neatly.