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.
Tutorials
CAST any Data Type as INTEGER
Learn how to CAST any data type to INTEGER in MySQL. Also, learn about what happens when each data type is converted to INTEGER.
Tips & Tricks
Check Database and Table Size
Learn how to check the MySQL database size and the size of the tables in the database. Multiple ways are mentioned in the article, on how to check database and table size.
Clone/Duplicate Table
Learn how to clone or duplicate tables in MySQL. You will learn to clone a table with data or without data. Multiple ways of cloning is discussed in this article.
Find and Delete Duplicate Rows
Learn how to clone or duplicate tables in MySQL. You will learn to clone a table with data or without data. Multiple ways of cloning are discussed in this article.
Pivot Table – Pivot Rows to Columns
Pivot tables are common in business. MySQL does not have an easy way to make a pivot table. In this article, we have discussed step by step how to generate a pivot table dynamically.
Select Latest Record for Each Group
In some cases, we need to find the latest record for a group of records. Like the latest record for employee salary or attendance or the latest record of weather data. Whatever the case, this tutorial will solve that problem for you. The process is discussed step by step in this article.
Errors
1045: Access denied for user
MySQL error number 1045(Access denied for user) is discussed in detail in this article. The reason behind it and the solution are discussed in detail. This article will help you to solve any issue that occurs because of MySQL error 1045.
1118: Row size too large
MySQL error number 1118(Row size too large ER_TOO_BIG_ROWSIZE) is discussed in detail in this article. The reason behind it and the solution are in this article.
1153: Got a packet bigger than ‘max_allowed_packet’ bytes
MySQL error number 1153 (Got a packet bigger than ‘max_allowed_packet’ bytes) is discussed in detail in this article. The reason behind it and the solution are discussed in detail. In this article, you will get multiple ways to solve MySQL error 1153.