From: Dan Nelson
Date: July 21 2002 1:25am
Subject: Re: Auto_Increment Starting Number
List-Archive: http://lists.mysql.com/mysql/115180
Message-Id: <20020721012531.GD40625@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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