Re: Does MySQl support Identity key?

[Sasha Pachev]

Hawke Robinson wrote:
> 
> I am converting the schema of a MS SQL 6.5 server over to MySQL.  But I
> just received an error not recognizing the statement IDENTITY wwhen I
> was creating a new table, and wanted the ID column to be
> CREATE TABLE SystemVer(ID int IDENTITY NOT NULL, PRIMARY KEY(ID),Name
> varchar(10) NOT NULL, Details varchar(100));
> Is there a better way to set that column up?
> Thanks
> -Hawke
> 

What is the effect of IDENTITY?  

-- 
Sasha Pachev
http://www.sashanet.com