title: set transaction isolation level at procedure scope in mysql
body: <p>How DO I set the transaction isolation level at proc level in Mysql. Do I have to use session or any other parameter. Right now we have to write at the Select query level. Sql server provides that you can write it once at the procedure level and it will be applicable for all the statements.</p>
  
  <pre><code>SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
  </code></pre>