version_major

Description

Returns the major version of MySQL Server.

Returns

TINYINT UNSIGNED

Example

mysql> SELECT VERSION(), sys.version_major(); +————————————–+———————+ | VERSION() | sys.version_major() | +————————————–+———————+ | 5.7.9-enterprise-commercial-advanced | 5 | +————————————–+———————+ 1 row in set (0.00 sec)