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