MySql set multiple variables from one select

mysql, stored-procedures

Solution

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

Problem

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

Original source