title: set auto increment initial value for mysql table
body: <p>I'm trying to create a table in my sql using PHP but I'm not sure how to set an initial value for the auto increment field.</p>
  
  <p><strong>This is what i have so far:</strong></p>
  
  <pre><code>function create_table($db_host,$db_user,$db_pswrd,$db_name){
  
  $connect = mysql_connect($db_host,$db_user,$db_pswrd) or die(mysql_error());
  
  mysql_select_db($db_name, $connect);
   $sql = "CREATE TABLE MY_TABLE
   (
  table_id int NOT NULL AUTO_INCREMENT, 
   PRIMARY KEY(table_id),
   table_1 varchar(45),
   table_2 varchar(45),
   table_3 varchar(999),
   table_4 varchar(45)
   )"or die(mysql_error());
  
   mysql_query($sql,$connect)or die(mysql_error());
  
  mysql_close($connect);
  
  }
  </code></pre>
  
  <p>So i need to know how to set the initial Auto Increment value on this table, upon creation?</p>
  
  <p>Thanks</p>