Creating and Using Views in MySQL

Example

CREATE VIEW emp_salary_view AS SELECT name, salary FROM employees WHERE salary > 50000;

SELECT * FROM emp_salary_view;