How to know MySQL server version.
There is a special MySQL function VERSION() which returns current server version:
1 |
<pre><code>SELECT VERSION(); |
Also, it is possible to determine version using global/session variables, e.g.:
1 2 3 4 |
<pre><code>SELECT * FROM INORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME LIKE '%version%'; |