In this blog post, we’ll compare virtual columns in MySQL and MariaDB.
Virtual columns are one of my top features in MySQL 5.7: they can store a value that is derived from one or several other fields in the same table in a new field. It’s a very good way to build a functional index. This feature has been available in MariaDB for some time, so let’s compare the two and see if they are equivalent. We’ll look at different aspects for this comparison.
Documentation
The MariaDB documentation is very easy to find.
Finding the documentation for virtual columns in 5.7 is a bit more challenging. …
[Read more]