Auto_Increment Stating Number
am 21.07.2002 02:35:32 von PathFinder SoftwareWhat 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?
Thanks,
Normand Charette
PathFinder Software
support@affiliatesoftware.net
------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread1869@lists.mysql.com
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@lists.mysql.com instead.