title: How to create two auto increment columns in MySQL?
body: <pre><code>CREATE TRIGGER test1 AFTER INSERT ON `course_metadata_31`
  FOR EACH ROW BEGIN
      UPDATE `course_metadata_31`
      SET `articleID` = `articleID` + 1
  END;
  </code></pre>
  <p>I am using this approach. When I will insert new entry in <code>course_metadata_31</code> it should increment <code>articleID</code> too. Because I want <code>articleID</code> as another auto increment column.</p>
  <p>What should I do?</p>