用mysql写出 创建函数根据员工姓名返回它的工资

DELIMITER $$ CREATE FUNCTION getSalaryByName(name VARCHAR(255)) RETURNS DECIMAL(10,2) BEGIN DECLARE salary DECIMAL(10,2); SELECT salary INTO salary FROM employees WHERE name = name; RETURN salary; END$$ DELIMITER ;