List:General Discussion« Previous MessageNext Message »
From:PathFinder Software Date:July 21 2002 4:22am
Subject:RE: Auto_Increment Starting Number
View as plain text  
Thanks Dan this one worked.

CREATE TABLE test ( ... ) AUTO_INCREMENT = 1500;

Normand

-----Original Message-----
From: Dan Nelson [mailto:dnelson@stripped]
Sent: Saturday, July 20, 2002 6:26 PM
To: PathFinder Software
Cc: mysql@stripped
Subject: Re: Auto_Increment Starting Number


In the last episode (Jul 20), PathFinder Software said:
> 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));

http://www.mysql.com/doc/C/R/CREATE_TABLE.html

CREATE TABLE test ( ... ) AUTO_INCREMENT = 1500;

> Also can an auto_increment value contain characters like 1500AB?

Nope.  Just integer values.

--
	Dan Nelson
	dnelson@stripped

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