title: Mysql equivalent of MS-Sql server IDENTITY field
body: <p>I have a sql-server query and i want to run it (or create an equivalent query) on mysql. But currently i'm getting syntax error. Can anyone help me to create a mysql equivalent of the below mentioned sql-server query?</p>
  
  <pre><code>create table Emp(EmpName varchar(20) not null,keyword varchar(20) not null,
  DOB datetime not null,Comments text(65535),EmpId int primary key IDENTITY(1,1));
  </code></pre>
  
  <p>Following is the error</p>
  
  <pre><code>ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that 
  corresponds to your MySQL server version for the right syntax to use near 'IDENTITY(1,1))' at line 1
  </code></pre>