如何从临时表中读取多个值并将其赋给变量

-- 创建临时表
CREATE TEMPORARY TABLE temp_values (
  id INT,
  value VARCHAR(50)
);

-- 插入数据
INSERT INTO temp_values (id, value) VALUES (1, 'Value 1');
INSERT INTO temp_values (id, value) VALUES (2, 'Value 2');
INSERT INTO temp_values (id, value) VALUES (3, 'Value 3');

-- 读取数据并赋值给变量
DECLARE @value1 VARCHAR(50);
DECLARE @value2 VARCHAR(50);
DECLARE @value3 VARCHAR(50);

SELECT value INTO @value1 FROM temp_values WHERE id = 1;
SELECT value INTO @value2 FROM temp_values WHERE id = 2;
SELECT value INTO @value3 FROM temp_values WHERE id = 3;

-- 输出变量的值
SELECT @value1, @value2, @value3;