MySQL - Get select query values in multiple vairables?

Jan 22 2013 6:34 AM

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