title: MySQL: Selecting multiple fields into multiple variables in a stored procedure
body: <p>Can I SELECT multiple columns into multiple variables within the same select query in MySQL? </p>
  
  <p>For example:</p>
  
  <pre><code>DECLARE iId INT(20);
  DECLARE dCreate DATETIME;
  
  SELECT Id INTO iId, dateCreated INTO dCreate 
  FROM products
  WHERE pName=iName;
  </code></pre>
  
  <p>What is the correct syntax for this?</p>