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 − Constraints Table of content MySQL Constraints The MySQL constraints can be used to set certain rules to the column(s) in a table. These constraints can restrict the type of data that can be inserted or updated in a particular column. This helps you to maintain the data accuracy and reliability in a table. […]

MySQL – Select Query Table of content Now that we have learned how to create tables in MySQL and insert values into it in the previous tutorials, the next step is to check whether the values are recorded in this table or not. To do this, one must use the SELECT statement to retrieve and […]