version_minor() - xiaoboluo768/mysql-system-schema GitHub Wiki

• 通过version()函数获取并返回MySQL server的次要版本号，该函数在MySQL 5.7.9中新增

  • 该函数执行时无需传入任何参数

• 返回值：一个TINYINT UNSIGNED值

• 定义语句

DROP FUNCTION IF EXISTS version_minor;

DELIMITER $$

CREATE DEFINER='root'@'localhost' FUNCTION version_minor ()
    RETURNS TINYINT UNSIGNED
    COMMENT '
            Description
            -----------

            Returns the minor (release series) version of MySQL Server.

            Returns
            -----------

            TINYINT UNSIGNED

            Example
            -----------

            mysql> SELECT VERSION(), sys.server_minor();
            +--------------------------------------+---------------------+
            | VERSION()                            | sys.version_minor() |
            +--------------------------------------+---------------------+
            | 5.7.9-enterprise-commercial-advanced | 7                  |
            +--------------------------------------+---------------------+
            1 row in set (0.00 sec)
            '
    SQL SECURITY INVOKER
    NOT DETERMINISTIC
    NO SQL
BEGIN
    RETURN SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(VERSION(), '-', 1), '.', 2), '.', -1);
END$$

DELIMITER ;

• 参考链接：https://dev.mysql.com/doc/refman/5.7/en/sys-version-minor.html

---

上一篇： version_major()函数 | 下一篇： version_patch()函数