MySQL DatabaseLesson 62Free preview
MySQL Views
This lesson is part of MySQL · All levels
Summary
View is a stored query that can be used like a table without storing the data itself in it. View simplifies complex queries, hides sensitive columns, and gives a consistent view to multiple users. View can be created with CREATE VIEW, updated with CREATE OR REPLACE VIEW, and deleted with DROP VIEW.
Key points
- View only stores the SELECT definition, not a copy of the data
- Made with the CREATE VIEW name US SELECT...
- Create or Replace View updates the view without deleting it first
- Ease the access restrictions of columns and simplify repeated queries
- With the check option, make sure the change through view remains in place.
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.