SELECT INTO 多个@variables MySQL

使用MySQL中的SELECT INTO多个@variables实现数据抽取

sql
SELECT column1, column2 INTO @variable1, @variable2
FROM your_table
WHERE your_condition;

sql
-- 创建一个用于测试的表
CREATE TABLE employees (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    salary DECIMAL(10, 2),
    department VARCHAR(50)
);
-- 插入一些测试数据
INSERT INTO employees (id, name, salary, department)
VALUES
    (1, 'John Doe', 50000.00, 'HR'),
    (2, 'Jane Smith', 60000.00, 'Finance'),
    (3, 'Bob Johnson', 75000.00, 'IT'),
    (4, 'Alice Williams', 70000.00, 'Finance');
-- 使用SELECT INTO将查询结果存储到变量中
SELECT name, salary INTO @employee_name, @employee_salary
FROM employees
WHERE department = 'IT';