title: MySql :: Select multi variables
body: <p>when I try to execute the following query :</p>
  
  <pre><code>SELECT filesinfo.IsFolder INTO @IsFolder, filesinfo.FileName 
  FROM filesinfo 
  WHERE filesinfo.FileID = 1; 
  </code></pre>
  
  <p>The following Error occurred :</p>
  
  <blockquote>
    <p>[<strong>SQL</strong>]  SELECT filesinfo.IsFolder INTO @IsFolder,
    filesinfo.FileName FROM filesinfo WHERE filesinfo.FileID = 1; [Err]
    1327 - <strong>Undeclared variable: filesinfo</strong></p>
  </blockquote>
  
  <p>But when remove the second parameter like this : </p>
  
  <pre><code>SELECT filesinfo.IsFolder INTO @IsFolder 
  FROM filesinfo 
  WHERE filesinfo.FileID = 1;
  </code></pre>
  
  <p>no errors occurred</p>