title: MySQL not commiting changes even with auto commit set
body: <p>I have the below syntax where I sorted the the date order, my default is autocommit enabled, however when I reopen the table it is not sorted again, is there some other syntax I should write to the below to make it permanent?</p>
  
  <p>Thanks</p>
  
  <pre><code>SELECT *
  FROM stock_price.spy1996
  ORDER BY Date ASC;
  </code></pre>