MySQL中的Deterministic关键字

CREATE PROCEDURE procedure_name()
    DETERMINISTIC
BEGIN
    -- 存储过程体
END;

CREATE FUNCTION function_name()
    RETURNS datatype
    DETERMINISTIC
BEGIN
    -- 函数体
END;

CREATE VIEW view_name
    AS
    SELECT column1, column2, ...
    DETERMINISTIC
    FROM table_name
    WHERE condition;

DELIMITER //
CREATE PROCEDURE get_employee_name(IN employee_id INT)
    DETERMINISTIC
BEGIN
    SELECT name FROM employees WHERE id = employee_id;
END;
//
DELIMITER ;

DELIMITER //
CREATE FUNCTION calculate_bonus(salary INT)
    RETURNS INT
    DETERMINISTIC
BEGIN
    DECLARE bonus INT;
    IF salary > 50000 THEN
        SET bonus = salary * 0.1;
    ELSE
        SET bonus = salary * 0.05;
    END IF;

    RETURN bonus;
END;
//
DELIMITER ;

CREATE VIEW high_salary_employees
    AS
    SELECT name, salary
    DETERMINISTIC
    FROM employees
    WHERE salary > 80000;