Syntax

VERSION()

Description

Returns a string that indicates the MariaDB server version. The string uses the utf8 character set.

Examples

SELECT VERSION();
+------------------------------+
| VERSION()                    |
+------------------------------+
| 10.0.3-MariaDB-1~precise-log |
+------------------------------+

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

SuffixDescription
-embeddedThe server is an embedded server (libmysqld).
-logGeneral logging, slow logging or binary (replication) logging is enabled.
-debugThe server is compiled for debugging.
-valgrind The server is compiled to be instrumented with valgrind.

Changing the version string

Some old legacy code may break because they are parsing the VERSION string and expecting a MySQL string or a simple version string like Joomla til API17, see MDEV-7780.

In MariaDB 10.2 one can fool these applications by setting the version string from the command line or the my.cnf files with --version=....

Comments

Comments loading...