title: Setting the starting value of an AUTO_INCREMENT field in MySQL
body: <p>I have a simple question in creating table in database. Here's my code:</p>
  
  <pre><code>$query="CREATE TABLE users (
      userid int(5) not null AUTO_INCREMENT, 
      firstname varchar(20),
      lastname varchar(20),
      username varchar(30),
      password varchar(32),
      email varchar(50),
      age int(2),
      PRIMARY KEY (userid)
  )";
  </code></pre>
  
  <p>I want the <code>USERID AUTO INCREMENT</code> to start in a <code>SPECIFIC NUMBER</code>.</p>
  
  <p>example, starting in 99001....</p>
  
  <p>How can I do that?</p>