MySQL - Get select query values in multiple vairables?

Vijay Yadav

Hi All,

I want to get the values of the column in variables.

For example: select Username, Amount Into Uname, amt from Table1

Here, username is varchar(50) and amount is in decimal but doesn't give me the value of any decimal column. If I will do query for only username it give me the value but not decimal column

Can anyone help out with this?

Thanks in advance!!

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vijay Yadav13y ago
Hi All, I tried this after couple of months, i don't know where I went wrong but the following stored procedure is not working. DELIMITER $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `testing`() BEGIN Declare Prize decimal(18,2) default 0; select Prize = Prizes from MyTable where Id=609; Select prize; END But if Into instead of Equal sign it works fine. Can any please help me out with this? Thanks!
Vijay Yadav13y ago
Hi Jignesh,

Thanks for your reply.

Aaah! I came to know the problem, actually i was using the variable same as the Column name in the stored procedure.

Now it is working fine..:)
Jignesh Trivedi13y ago
hi,

correct me! you want to store column data in to some varible in SQL server.

I have try with below code.

Create table #temp(UserName varchar(50), Amount decimal(10,6))
insert into #temp values('Jignesh', 23.63)
insert into #temp values('Tejas', 25.63)
insert into #temp values('Rakesh', 27.63)
Declare @Username varchar(50)
declare @Amount decimal(10,6)
select @Username = UserName, @Amount = Amount from #temp where UserName = 'Jignesh'
Print @Username
print @Amount
Let me know, you required more help.
hope this will help you.