midMySQL
Virtual Tables with Views
Updated May 4, 2026
Short answer
A stored query that behaves like a table.
Deep explanation
Views do not store data. They simplify complex queries and can act as a security layer by limiting column access.
Real-world example
Hiding sensitive columns like 'salary' from general reporting users.
Common mistakes
- Treating a complex view like a physical table and forgetting it runs the query every time.
Follow-up questions
- Are views updatable?