Category Archives: mysql

MySQL – Rename View Table of content Renaming Views in MySQL The MySQL RENAME TABLE statement in MySQL is generally used to rename the name of a table. But this statement can also be used to rename views because views are typically virtual tables created by a query. Before renaming a view, we need to […]

MySQL – Drop View Table of content A MySQL View is a virtual table which is generated from a predefined SQL query. It contains (all or selective) records from one or more database tables. Views are not stored in a database physically, but they can still be dropped whenever not necessary. Even though they are […]

MySQL – Derived Tables Table of content MySQL Derived Tables The Derived tables are pretty much what their name describes: they are the tables that are derived from another MySQL database table (main table). In other words, the derived table is a virtual result-set obtained from a SELECT statement given as a subquery to another […]