MySQL: select multiple fields into variables
Posted January 3, 2009 
Comments(0)
Comments(0) Just reminder that MySQL statement for selecting more than one field into variables should look like below:
SELECT ID, `Name` INTO UserID, UserName FROM `User` WHERE ID = 100; |
I.e. single INTO per SELECT statement instead of own INTO for each field.