version_patch()

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

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

• 返回值：一个TINYINT UNSIGNED值

• 定义语句

DROP FUNCTION IF EXISTS version_patch;

DELIMITER $$

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

            Returns the patch release version of MySQL Server.

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

            TINYINT UNSIGNED

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

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

DELIMITER ;

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

---

上一篇： version_minor()函数 | 结束