带if...else的存储过程

#带if语句的存储过程

DELIMITER //
CREATE PROCEDURE addSalary(money FLOAT,idd BIGINT)
BEGIN
            IF (m>0) THEN  
                                UPDATE emp SET salary=salary+money WHERE id=idd;
            END IF;
END //
DELIMITER ;


#带if...else的存储过程
DELIMITER //
CREATE PROCEDURE addSalary(money FLOAT,idd BIGINT)
BEGIN
            IF (m>0) THEN  
                                UPDATE emp SET salary=salary+money WHERE id=idd;
            ELSE
                           SELECT 'dsfshj ' as 提示信息;
            END IF;
END //
DELIMITER ;

CALL addSalary (1,1000);