Creating and Using Views in MySQL

Create a View

CREATE VIEW high_salary_emps AS 
SELECT name, salary FROM employees WHERE salary > 60000;

Use the View

SELECT * FROM high_salary_emps;

Views can simplify complex joins and calculations.