VERSION

You are viewing an old version of this article. View the current version here.

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...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.