MySQL - Get select query values in multiple vairables?

Question

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!!

Vijay Yadav · Answer

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(182) 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 Yadav · Answer

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 Trivedi · Answer

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(106)) 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(106) 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.