MySQL transactions can be read only. Here’s how to use them, and why they are useful.
Reducing the number of queries is important. The article describes how to use the SQL language more expressively (in MySQL) to achieve the purpose.
MariaDB 10.3 supports stored aggregate functions. Let’s see how to create them with examples.
Stored procedures are considered slow and not scalable, especially in the MySQL world. But in some cases they can increase an application speed and scalability.
MySQL JSON types has a rich set of functions. This allows us to use JSON to simulate native objects.
Let’s create a table that always contains a fixed amount of rows, using MariaDB 10.3.
Any comparison involving at least one NULL operand will return NULL. However, SQL supports operators to easily write NULL-safe comparisons.
MySQL and MariaDB provide different ways to concatenate strings. Including ways to deal with NULLs.
When you write stored procedures in MySQL or MariaDB, one of the missing features is an ARRAY type. But actually, it is possible to create arrays by using the JSON type. This article explains how to work with JSON arrays.