mysql-if-1.sql

CREATE PROCEDURE SP_COMPARE(a INT, b INT)
BEGIN
    DECLARE message VARCHAR(100) DEFAULT "";
    IF a > b THEN
        SET message = CONCAT("The first parameter is greater than the second parameter.", a, ">", b);
        ELSEIF a < b THEN
            SET message = CONCAT("The first parameter is less than the second parameter.", a, "<", b);
        ELSE
            SET message = CONCAT("Values of both parameters are the same.", a, "=", b);
    END IF;
    SELECT message AS "Message";
END;