Category Archives: mysql

MySQL – Create Index Table of content A database index improves the speed of operations in a database table. They can be created on one or more columns, providing the basis for both rapid random lookups and efficient ordering of access to records. Practically, indexes are a special type of lookup tables, that hold a […]

MySQL − Queries Table of content MySQL is an open-source relational management system (RDBMS) that allows us to store and manage data or information. The queries in MySQL are commands that are used to retrieve or manipulate the data from a database table. Following are the commonly used commands in MySQL: SELECT, UPDATE, DELETE, INSERT […]

MySQL – Drop Index Table of content The DROP statement in MySQL database is used to remove or delete an existing database object such as a table, index, view, or procedure. Whenever we use DROP statement with any of the database objects, like indexes, it will remove them permanently along with their associated data. Therefore, […]