Can I SELECT multiple columns into multiple variables within the same select query in MySQL?
DECLARE iId INT(20);
DECLARE dCreate DATETIME;
SELECT Id INTO iId, dateCreated INTO dCreate
Your syntax isn't quite right: you need to list the fields in order before the INTO, and the corresponding target variables after:
SELECT Id, dateCreated INTO iId, dCreate FROM products WHERE pName = iName