MySQL Date TypesMySQL LAST_INSERT_IDMySQL InsertMySQL SelectMySQL WhereMySQL Group ByMySQL Order ByMySQL LimitMySQL LikeMySQL ISNULLMySQL BetweenMySQL JoinMySQL Left JoinMySQL Right JoinMySQL Cross JoinMySQL Self JoinMySQL Sub QueryMySQL UpdateMySQL DeleteMySQL ExplainMySQL IfMySQL Full-Text SearchMySQL INFORMATION_SCHEMAMySQL ConnectionMySQL Server Helpful FunctionsMySQL ViewMySQL Stored ProcedureMySQL FunctionsMySQL TransactionMySQL TriggerMySQL EventMySQL DeadlockMySQL DumpMySQL Reset Root PasswordMySQL interview – Advanced QueriesMySQL JsonMySQL BinlogMySQL Closure Table
MySQL View
Views are virtual tables what consist of columns and rows from real tables within a database. Views don’t contain the data they display. Views are practically for read-only but some databases allow updating on views.
Here is how you create a view.
CREATE VIEW view_name AS SELECT column_name1, column_name2, ... FROM table_name WHERE condition;
You can just JOINs if needed to generate your SELECT statement. Here is how views are created.
Advantages of Views
- A database view simplifies the complexity of a query. The underlying view might consist of a complex query like multiple joins and subqueries so calling a view by a simple select statement really helps reduce the code you have to write.
- A database view can have calculated columns.
- A database view can be created based off of another view.
Disadvantages of Views
- Table dependency.
- Slowness in performance if views are derived from other views.
- Views cannot have indexes. Only the underlying tables have indexes.
- If you rename a column name on the underlying table, MySQL does not throw an exception.
- Views based on complex queries such as JOINs and sub queries are not updatable. Simple select statement views are updatable.
Views and tables share the same namespace so views cannot be named the same name of an existing table.
MySQL Date TypesMySQL LAST_INSERT_IDMySQL InsertMySQL SelectMySQL WhereMySQL Group ByMySQL Order ByMySQL LimitMySQL LikeMySQL ISNULLMySQL BetweenMySQL JoinMySQL Left JoinMySQL Right JoinMySQL Cross JoinMySQL Self JoinMySQL Sub QueryMySQL UpdateMySQL DeleteMySQL ExplainMySQL IfMySQL Full-Text SearchMySQL INFORMATION_SCHEMAMySQL ConnectionMySQL Server Helpful FunctionsMySQL ViewMySQL Stored ProcedureMySQL FunctionsMySQL TransactionMySQL TriggerMySQL EventMySQL DeadlockMySQL DumpMySQL Reset Root PasswordMySQL interview – Advanced QueriesMySQL JsonMySQL BinlogMySQL Closure Table