List:General Discussion« Previous MessageNext Message »
From:PathFinder Software Date:July 21 2002 12:47am
Subject:Auto_Increment Starting Number
View as plain text  
What is the syntax for starting an Auto_Increment at a certain value like
1500 for example?

I have tried this string but MySQL gives me an error.

CREATE TABLE Test (TestID int not null auto_increment auto_increment =
1500,Year INT,Month INT,Day INT,Name VARCHAR(50));

Also can an auto_increment value contain characters like 1500AB?


Normand Charette
PathFinder Software

Please check "" before
posting. To request this thread, e-mail

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@stripped instead.

Auto_Increment Starting NumberPathFinder Software21 Jul
  • Re: Auto_Increment Starting NumberDan Nelson21 Jul
    • RE: Auto_Increment Starting NumberPathFinder Software21 Jul