MySQL数据库程序设计套题⑧【真题截图+原理解析】

DELIMITER //
CREATE FUNCTION fn_yggl(eid CHAR(4))
_____________ CHAR(20)--returns
DETERMINISTIC
BEGIN
    DECLARE workage INT;
    DECLARE newsalary FLOAT;
    SELECT YEAR(CURDATE())-SUBSTRING(worktime,1,4) INTO  workage FROM tb_emp WHERE eno=eid;
    IF ______________ THEN--workage >=30
        UPDATE tb_emp SET salary=salary*1.05 WHERE eno=eid;
        RETURN('工资已经更新');
    ELSE
        RETURN('工作年限不够，工资不能更新');
    END IF;
END //
DELIMITER ;
SELECT __________('1118');--fn_yggl（调用）