mysql -设置临时变量以存储超过1条记录？

DECLARE cur CURSOR FOR SELECT column_name FROM table_name WHERE condition;

OPEN cur;

DECLARE @temp_variable data_type;

FETCH NEXT FROM cur INTO @temp_variable;

WHILE @@FETCH_STATUS = 0
BEGIN
    -- 在这里可以对临时变量进行操作
    -- 例如，将临时变量插入到另一个表中
    INSERT INTO another_table (column_name) VALUES (@temp_variable);

    FETCH NEXT FROM cur INTO @temp_variable;
END;

CLOSE cur;

DEALLOCATE cur;