mysql 怎么多个赋值给变量

SELECT column1, column2, column3
INTO @var1, @var2, @var3
FROM table_name
WHERE condition;

SET @var1 = (SELECT column1 FROM table_name WHERE condition);
SET @var2 = (SELECT column2 FROM table_name WHERE condition);
SET @var3 = (SELECT column3 FROM table_name WHERE condition);

SELECT column1 INTO @var1, column2 INTO @var2, column3 INTO @var3
FROM table_name
WHERE condition;

SET @var1 = NULL;

SELECT COUNT(*) INTO @row_count FROM table_name WHERE condition;
IF @row_count > 0 THEN
    SELECT column1, column2, column3 INTO @var1, @var2, @var3 FROM table_name WHERE condition;
ELSE
    -- 处理没有结果的情况
END IF;