MariaDB introduced the UUID data type in version 10.7. The first long-term support (LTS) version to include it is 10.11, which was declared stable in February 2023.
MariaDB supports several ways to compose strings dynamically. Some of them might be well-known, others aren't familiar to you. This article covers all the ways to compose strings.
Vettabase specialises in expert consulting and automation for your database infrastructure. We offer professional services and training for MySQL, MariaDB, PostgreSQL and Cassandra.