MySql 从一个选择中设置多个变量 [英] MySql set multiple variables from one select

问题描述

我要开始拔头发了，这可能吗?

I'm starting to pull my hair out here is something like this even possible?

DECLARE var1 int;
DECLARE var2 int;
DECLARE var3 int;
SELECT var1:=id, var2:=foo, var3:=bar from page WHERE name="bob";
CALL someAwesomeSP (var1 , var2 , var3 );

上述方法不起作用，但我想弄清楚如何实现这一点.我的最终目标是调用一个选择，而不是使用来自选择的数据调用存储过程.
谢谢

The above doesn't work but i am trying to figure out how I would accomplish this. My ultimate goal here is to call a select and than call stored proc with data from select.
Thanks

推荐答案

这对我有用.

        DECLARE var1 int;
        DECLARE var2 int;
        DECLARE var3 int;
        SELECT id, foo, bar INTO var1, var2, var3 from page WHERE name="bob";
        CALL someAwesomeSP (var1 , var2 , var3 );

感谢 Zec.第一个链接帮助我理解了正确的语法，或者至少是什么对我有用.

Thanks to Zec. The first link helped me understand the correct syntax or at least what is working for me.

这篇关于MySql 从一个选择中设置多个变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！