SELECT INTO Multiple Variable in MySQL declaration

Question

Is that possible to set two parameters value in single query in Stored Procedure Mysql? I want , two different parameters as output , i don't want to con-cat it.

Declare v_first_name varchar(100);
Declare v_last_name Varchar(100);

SET p_email_id = 'some_email_id';

/* 
instead of this i want to laod result in single query   
Set v_first_name=(Select first_name From user_master Where email_id=p_email_id);
Set v_last_name=(Select last_name From user_master Where email_id=p_email_id);

*/

if flag1=1 then 
Select 1 As 'Result',v_first_name As 'first_name',v_last_name As 'last_name';  
else    
Select 0 As 'Result',v_first_name As 'first_name',v_last_name  As 'last_name';
End if;

Any help ?

select first_name INTO @v_first_name , last_name INTO @v_last_name From user_master Where email_id=p_email_id; ==== **Not Working**

siride · Accepted Answer · 2013-05-08 16:59:45Z

11

Just list them out with commas after the INTO:

SELECT a, b, c
INTO v_a, v_b, v_C
FROM ...

answered May 8, 2013 at 16:59

siride

212k5 gold badges43 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Kailas Over a year ago

Hi @siride. How can get these value in next select query like (SELECt id, name, v_a as value1, v_b as value2 FROM table WHERE id =1)

siride Over a year ago

@Kailas: I don't understand the question. Your example SELECT is exactly how you'd get them out.

Fakipo Over a year ago

why is this not working inside a concat query in stored procedure?

siride Over a year ago

@Fakipo Did you declare the variables first? I'd ask in a new question first.

Fakipo Over a year ago

No, it works. we just have to use user defined variables..

Collectives™ on Stack Overflow

SELECT INTO Multiple Variable in MySQL declaration

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related