List:General Discussion« Previous MessageNext Message »
From:Jay Miller Date:July 2 1999 12:46pm
Subject:RE: Does MySQl support Identity key?
View as plain text  
IDENTITY is AUTO_INCREMENT

CREATE TABLE SystemVer(ID int NOT NULL AUTO_INCREMENT, PRIMARY KEY(ID),Name
varchar(10) NOT NULL, Details varchar(100));

> -----Original Message-----
> From: apachev@stripped
> [mailto:apachev@stripped]On Behalf Of Sasha Pachev
> Sent: Thursday, July 01, 1999 11:10 PM
> To: Hawke Robinson
> Cc: mysql@stripped
> Subject: Re: Does MySQl support Identity key?
>
>
> 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
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread6420@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>

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