How do you create a View in MySQL?

Difficulty: 3/10

CREATE VIEW syntax, view performance, view maintenance

How to Create a View in MySQL

Creating a view in MySQL involves defining a SELECT query and saving it under a view name. The view acts like a virtual table that returns the result of that SELECT whenever queried.

Steps to Create a View

1
Write a SELECT query that represents the data you want in the view.
2
Use the CREATE VIEW statement followed by the view name.
3
Assign the SELECT query to the view using AS.
4
Optionally apply conditions or joins inside the SELECT statement.

Basic Syntax

Example: Creating a View of Active Users

Using the View

Optional: Creating or Replacing a View

1
Use CREATE OR REPLACE VIEW to update a view without dropping it.
2
This avoids errors if the view already exists.

Example: Replace Existing View

In summary, a view is created using a standard SELECT query wrapped inside a CREATE VIEW statement, making it easy to reuse and centralize query logic.

Scenario Questions

0-2 years experience

Follow-up Questions