title: MySQL How do I loop a stored procedure?
body: <p>I have a stored procedure called <strong>Evaluate(something1, something2);</strong>
  Evaluate will take a some parameters, search for them in the database and insert findings into a result table.</p>
  
  <p>Now I wish to create some type of stored procedure that will constantly call Evaluate to iterate over an entire comma-delimited file. Is this possible?</p>
  
  <p><strong>psuedo code</strong></p>
  
  <pre><code>assessEntireFile()
  {
    loop file
      Evaluate(single line from file)
     end loop
  }
  
  
  
  **The work flow of assessEntireFile() will be as followed:**
  1. call assessEntireFile()
     --assessEntireFile will load and iterate over an input file (line-by-line)
  2. each iteration will call Evaluate() on that line
     --evualte() will produce results in a table
  3. complete
  </code></pre>