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 ;