Calculate Image ratio function for MySql and MariaDB

calc_ration.sql

DELIMITER $$

DROP FUNCTION IF EXISTS calc_ratio;

CREATE FUNCTION calc_ratio(width int,
                           height int)
    RETURNS VARCHAR(10)
    DETERMINISTIC
BEGIN
    DECLARE ratio VARCHAR(10);
    declare tmp1 float;
    declare tmp2 float;
    declare i int unsigned default 0;
    declare mywidth int unsigned default 0;
    declare myheight int unsigned default 0;

    set mywidth = width;
    set myheight = height;
    set i = height;

    while i > 1
        do
            set tmp1 = mod(mywidth, i);
            set tmp2 = mod(myheight, i);
            if tmp1 = 0 && tmp2 = 0 then
                set mywidth = mywidth / i;
                set myheight = myheight / i;
            end if;
            set i = i - 1;
        end while;

    set ratio = concat(mywidth, ':', myheight);
    return ratio;

END$$
DELIMITER ;

Result: