MySQL: JSON [Data Type]
JSON data type is introduced in MySQL 5.7.8. Here are the methods we can use to create/modify/search JSON type columns in MySQL.
MySQL
MySQL: Error 1118 – Row size too large
Error Number: 1118; Error Message: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs.
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: Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
If data sent to MySQL is larger than “max_allowed_packet” then the request fails. Increase the value of “max_allowed_packet“ to fix this.
MySQL: Pivot Table – Pivot Rows to Columns Dynamically
In this article, we will see how to implement a pivot table in MySQL. We will do that step by step, so that it becomes clear, what we are doing and why we are doing it.
MySQL: Clone/Duplicate Table (with or without data)
This article will show different ways to clone or duplicate a MySQL table. All the available methods are discussed. Choose the process which suits your need.
MySQL: Find and Delete Duplicate Rows (for single/multiple columns)
In this article, I will discuss 2 ways to get rid of duplicate rows from your MySQL database table. The first one will work for any MySQL version, but the second one will work for MySQL 8 or later version.
MySQL: CAST any Data Type as INTEGER
To CAST any data type to Integer in MySQL, you need to CAST it as SIGNED (for getting a signed integer) or UNSIGNED (for getting unsigned integer).
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.
MySQL: 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.