Category Archives: mysql

MySQL – GROUP BY Clause Table of content MySQL GROUP BY Clause The GROUP BY clause in MySQL is used to arrange identical data in a table into groups. For example, let us suppose you have a table of sales data of an organization consisting of date, product, and sales amount. To calculate the total […]

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