Virtual and persistent columns
We described a view on a virtual table, meaning that its contents are the results of a query. The idea behind virtual columns is very similar: they are columns based on SQL expressions.
A virtual column overview
The terminology is a bit confusing here. In fact, all automatically calculated columns are called virtual columns in MariaDB KnowledgeBase. However, there are two types of virtual columns:
VIRTUAL columns and
VIRTUALcolumn is calculated on-the-fly when it is referenced in a statement—for example, when a
SELECTclause extracts its value. This is the default type.
PERSISTENTcolumn is written in the table and its value can be read when needed, as happens with regular columns.