Creating and Using Views in MySQL
Published September 09, 2026
By Sai Sree Ram Gundepudi
Example
CREATE VIEW emp_salary_view AS SELECT name, salary FROM employees WHERE salary > 50000;
SELECT * FROM emp_salary_view;