title: MySQL Workbench - Altering Next Auto Increment Value does not Work
body: <p>I am trying to change what the next auto increment value will be for a given table using MySQL workbench. The next auto increment value is currently set to 3, and I am trying to make it 2. Whenever I try to apply the changes, the workbench runs the following code.</p>
  
  <pre><code>ALTER TABLE `mysql_schema`.`mysql_table` 
  AUTO_INCREMENT = 2 ;
  </code></pre>
  
  <p>After running this code however, the change is not applied, and the next auto increment value is still three. What's the problem? Why is the auto increment value not changing? I have tried to manually execute the code, but it did not work either.</p>