Hi First, auto increment is a column type. You set the column to add one to the highest value in that column. If you would like the records to start at 10, either enter you "first" record with the Client_ID value explicitly set at 10 or enter a dummy MySQL statement like "INSERT INTO Clients Client_ID VALUES (9)" then the next Full_Name you enter, the Client_ID will be automatically set at 10, then next 11 and so on.
Mike ----- Original Message ----- From: "Fandango del Morro" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: June 22, 2003 3:35 AM Subject: Big problem with autoincrementing > > Hello, > I'm new in this list and I also a newbie with MySql. I have a big problem > with autoincrementing with an initial value. For example: > > use Database Business; > create Table Clients(Client_ID int not null primary key auto_increment=10, > Full_Name varchar(30)); > > Each time I assign an initial value to auto_increment I get an error and > worse, the MySql server only tell me there is an error, it doesn't tell me > what kind of error is. > > I tried at leat 30 times before writing this message. I really unable to > solve this problem. auto_increment=n is an accepted syntax and it is > documented in all sql books. > > Can you explain me why I have this problem? > > Thanks > Fandango > > _________________________________________________________________ > The new MSN 8: advanced junk mail protection and 2 months FREE* > http://join.msn.com/?page=features/junkmail > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]