Category Archives: mysql

MySQL – Update View Table of content The MySQL UPDATE statement is used on various database objects to update the existing data in them. This is a DML (Data Manipulation language) command. We need to be careful while using the UPDATE statement as it can modify all the records in an object, if not selected […]

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. […]

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 […]