MySQL Tutorials

As one of the most popular and most used databases, MySQL is used by a huge number of developers. To address the issues that developers face related to MySQL, this tutorial series is created. Here is the list of articles for MySQL that will help you to handle the MySQL database better and also fix the errors that you get while using MySQL.

MySQL: Check Database and Table Size

This process will work in all cases, whether you are accessing your database through the command line or using any GUI tool (like MySQL Workbench or HeidiSQL). Because the size-related information is already saved in a specific MySQL table. Check the table named “TABLES” from the database “information_schema”, you will find all the information related to the sizes of the tables.

SQL: Select Latest Record for Each Group

Select Latest Record for Each Group

In this article, we are discussing the process of getting the latest records for each group using SQL. For the demonstration, we have some data in a table (check the table below). In the table, there is entry_id, which is the primary key, there is city which is the name of the city, there is date, and rain_measurement.