In MariaDB, VERSION() is a built-in function that returns the MariaDB server version.

The result is a string that uses the utf8 character set.

Syntax

The syntax goes like this:

VERSION()

No arguments are required, or accepted.

Example

Here’s an example to demonstrate:

SELECT VERSION();

Result:

+----------------+
| VERSION()      |
+----------------+
| 10.5.9-MariaDB |
+----------------+

The VERSION() string may have one or more of the following suffixes:

Suffix	Description
-embedded	The server is an embedded server (libmysqld).
-log	General logging, slow logging or binary (replication) logging is enabled.
-debug	The server is compiled for debugging.
-valgrind	The server is compiled to be instrumented with valgrind.