title: Mysql table with more than one Auto-Incremented column
body: <p>I have a table with the following structure:</p>
  
  <pre><code> id |  number |  text
  ----------------------
    1 |    1    |  test
  </code></pre>
  
  <p>in which, <strong>id</strong> is my primary key with auto increment value. I want to make number as auto increment value too. Is it possible to have more than one auto increment column in one table?</p>