title: MySQL how do you truncate a table in a stored procedure?
body: <p>I have a stored procedure that writes results to a Result table. How do you truncate / erase a table from within a stored procedure?</p>
  
  <p>example </p>
  
  <pre><code>call peformTest()
  
  truncate TestResultTable;
  
  //do stuff with new data to insert into TestResultTable
  end
  </code></pre>