title: SQL create table and set auto increment value without Alter table
body: <p>For example I am creating the following table:<br></p>
  
  <blockquote>
    <p>CREATE TABLE Persons (<br> 
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ID int NOT NULL AUTO_INCREMENT,<br> 
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;LastName
    varchar(255) NOT NULL,<br> 
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FirstName varchar(255),<br>
    &nbsp;&nbsp;&nbsp;&nbsp; Address varchar(255), <br>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PRIMARY KEY (ID) <br>)</p>
  </blockquote>
  
  <p>As I know, the value of Auto increment can be modify by Alter table like this<br></p>
  
  <blockquote>
    <p>ALTER TABLE Persons AUTO_INCREMENT=100;</p>
  </blockquote>
  
  <p>But I just want to know is there a way to set the value of Auto Increment while creating the table?<br> Somthing like this?</p>
  
  <blockquote>
    <p>CREATE TABLE Persons (<br> 
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ID int NOT NULL AUTO_INCREMENT = 100,<br> 
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;LastName
    varchar(255) NOT NULL,<br> 
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FirstName varchar(255),<br>
    &nbsp;&nbsp;&nbsp;&nbsp; Address varchar(255), <br>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PRIMARY KEY (ID) <br>)</p>
  </blockquote>