mysql 定义结果集变量

DELIMITER //

CREATE PROCEDURE GetEmployeeSalary(IN employee_name VARCHAR(255), OUT salary DECIMAL(10, 2))
BEGIN
    SELECT salary INTO salary FROM employees WHERE name = employee_name;
END //

DELIMITER ;

-- 调用存储过程
CALL GetEmployeeSalary('John Doe', @salary);
SELECT @salary;

DELIMITER //

CREATE PROCEDURE GetDepartmentEmployees(IN department_id INT)
BEGIN
    DECLARE employees_table TABLE (
        employee_id INT,
        employee_name VARCHAR(255),
        salary DECIMAL(10, 2)
    );

    INSERT INTO employees_table (employee_id, employee_name, salary)
    SELECT id, name, salary FROM employees WHERE department_id = department_id;

    -- 在这里可以对employees_table进行进一步处理
    SELECT * FROM employees_table;
END //

DELIMITER ;

-- 调用存储过程
CALL GetDepartmentEmployees(1);

DECLARE salary DECIMAL(10, 2);

DELIMITER //

CREATE PROCEDURE MyProcedure()
BEGIN
    DECLARE myVar INT;
    -- 在这里可以使用myVar
END //

DELIMITER ;

DECLARE salary DECIMAL(10, 2);
SELECT salary INTO salary FROM employees WHERE id = 1;