26.4.5.20 The version_major() Function

This function returns the major version of the MySQL server. It was added in MySQL 5.7.9.

Parameters

None.

Return Value

A TINYINT UNSIGNED value.

Example

mysql> SELECT VERSION(), version_major();
+-----------------+-----------------+
| VERSION()       | version_major() |
+-----------------+-----------------+
| 5.7.9-debug-log |               5 |
+-----------------+-----------------+