CREATE, ALTER & DROP VIEW
Learn CREATE, ALTER & DROP VIEW (Views, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction A view is a named, stored SELECT . It holds no data of its own; every time you query it, MySQL runs the underlying query. CREATE VIEW defines it, ALTER VIEW (or CREATE OR REPLACE ) changes it, DROP VIEW removes it.