title: MySQL - Auto_increment by 10
body: <p>How do I set the auto_increment column in such a way that it increments by 10 for each record insert. </p>
  
  <p>For eg: Instead of the default <code>auto_increment</code> by 1, </p>
  
  <pre><code>insert into temptable (name) values('abc'),('def');
  
  select * from temptable;
    id|name
    1|abc
    2|def
  
  auto_increment by 10,
    id|name
    10|abc
    20|def
  </code></pre>