MariaDB VERSION() Function
In MariaDB, VERSION() is a built-in function that returns a UTF8 string representing the version of MariaDB server.
MariaDB VERSION() syntax
Here is the syntax of the MariaDB VERSION() function:
VERSION()
Parameters
The MariaDB VERSION() function do not require any parameters.
Return value
The MariaDB VERSION() function return a string that represents the version of the MariaDB server.
VERSION() strings can have one or more of the following suffixes:
| Suffix | Describe |
|---|---|
-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. |
MariaDB VERSION() Examples
The following example shows how to use the VERSION() function to get the version of the MariaDB server.
SELECT VERSION();
Output:
+-----------------+
| VERSION() |
+-----------------+
| 10.10.2-MariaDB |
+-----------------+Conclusion
In MariaDB, VERSION() is a built-in function that returns a UTF8 string representing the version of MariaDB server.