title: Is there a way to get the default value of autocommit in MySQL?
body: <p>I'm just wondering as per the title if this can be done? For example, if I was to do something like this:</p>
  
  <pre><code>$this-&gt;db-&gt;autocommit(false);
  </code></pre>
  
  <p>But then afterwards I wanted to set it back to it's default value; I can't just assume it's defaults to true and do this:</p>
  
  <pre><code>$this-&gt;db-&gt;autocommit(true);
  </code></pre>
  
  <p>I would like to reset it back to it's default value if possible; or what do other people do when wanting a single query to auto commit? Do you always run:</p>
  
  <pre><code>$this-&gt;db-&gt;autocommit(true);
  </code></pre>
  
  <p>...before the query to make sure that <code>autocommit</code> is on?</p>