List:General Discussion« Previous MessageNext Message »
From:Hawke Robinson Date:July 2 1999 12:15am
Subject:Does MySQl support Identity key?
View as plain text  
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

--
CNA, MCP+I, MCSE, AS in CS, and more on the way...
Solaris Admin, Java Programmer, CNE+I, MCSE+I, CCNA.

Gee, I'm tired, can't imagine why..... :)


Thread
Does MySQl support Identity key?Hawke Robinson2 Jul
  • Re: Does MySQl support Identity key?Sasha Pachev2 Jul
    • RE: Does MySQl support Identity key?Jay Miller2 Jul
      • RE: Does MySQl support Identity key?Michael Widenius2 Jul