title: Mysql disable auto_increment column temporary in Stored procedure
body: <p>In sql server there is a something like</p>
  
  <p>IDENTITY_INSERT is set to OFF  and we can set in ON after</p>
  
  <p>I wanna know is that something similar in mysql where i need to temporary set off and set ON i.e like</p>
  
  <pre><code>create procedure ()
  
      begin   
        IDENTITY_INSERT is set to OFF
        Some insert statement
        Some insert statement
        IDENTITY_INSERT is set to ON 
      end
  </code></pre>