MySQL – INDEXES An index is a data structure that improves the speed of operations on a database table. They are a special type of lookup tables pointing to the data. Indexes can be created on one or more columns, providing the basis for both rapid random lookups and efficient ordering of access to records. […]
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 […]