MySql set multiple variables from one select

Question

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

Answer 1

This worked for me.

        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 ); 

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

Answer 2

For MySQL, please take a look this example code:

-- Init variables SET @var1 = 0; SET @var2 = 0; SET @var3 = 0; SELECT VALUE1, VALUE2, VALUE3 INTO @var1, @var2, @var3 FROM COOL_TABLE WHERE VALUE_ID = 12345;  -- Then you can use declared variables SELECT * FROM ANOTHER_TABLE WHERE VALUE1 = @var1 AND VALUE2 = @var2