title: Modifying the "settings" of the MySQL stored procedures
body: <p>According to the MySQL documentation, stored procedures are executed with the <code>sql_mode</code> in which they were created.</p>
  <p>I need to change the sql_mode parameter for a specific stored procedure</p>
  <p><code>SHOW CREATE PROCEDURE</code> command - shows the current sql_mode
  <code>STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION</code></p>
  <p>How can it be changed, specifically - remove strict mode</p>
  <p>Thanks</p>