Hi! I have now updated the manual to reflect this restriction on InnoDB tables:
" You cannot set the first AUTO_INCREMENT column value in InnoDB with CREATE TABLE ... AUTO_INCREMENT=... (or ALTER TABLE ...). To set the value insert a dummy row with a value one less, and delete that dummy row. " Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ ----- Original Message ----- From: "Becoming Digital" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, June 02, 2003 10:15 AM Subject: Re: ALTER TABLE > Is 'id' indexed? AUTO_INCREMENT fields must be to work correctly. Try this: > > ALTER TABLE users > ADD INDEX idx_id (id), > AUTO_INCREMENT=1000; > > > Quite honestly, your ID field should probably be the primary key, so: > > ALTER TABLE users > MODIFY id INT(9) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, > AUTO_INCREMENT=1000; > > Edward Dudlik > Becoming Digital > www.becomingdigital.com > > > ----- Original Message ----- > From: "Lilian" <[EMAIL PROTECTED]> > To: "Becoming Digital" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Monday, 02 June, 2003 02:28 > Subject: Re: ALTER TABLE > > > I have check http://www.mysql.com/doc/en/ALTER_TABLE_problems.html but no > solution for my problem. > > I have table_name 'users' (TYPE=InnoDB) with one of field id > > id int(9) unsigned NOT NULL auto_increment, > > when I update last insert id to 1000 , mysql 3 add next data automatically > with 1001, 1002 etc. > version 4 add data with id 3, 4 etc, it not check the value of last ID. > > I want to know if there are some solution, I need to start that ID from 1000 > not from 1. > > lilian > > > > ----- Original Message ----- > From: "Becoming Digital" <[EMAIL PROTECTED]> > To: "Lilian" <[EMAIL PROTECTED]> > Sent: Monday, June 02, 2003 9:04 AM > Subject: Re: ALTER TABLE > > > > Did you check http://www.mysql.com/doc/en/ALTER_TABLE_problems.html for > info? > > > > Edward Dudlik > > Becoming Digital > > www.becomingdigital.com > > > > > > ----- Original Message ----- > > From: "Lilian" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Monday, 02 June, 2003 01:17 > > Subject: ALTER TABLE > > > > > > Hi, > > I have tested that function > > > > ALTER TABLE table_name_here AUTO_INCREMENT = 1000; > > > > on version 4.0.12 and it's not working. > > (table TYPE=InnoDB) > > > > in 3.23.54 that is OK > > > > does anybody know what's wrong here? > > > > regards, > > lilian > > > > -- > > 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] > > > > > > -- > 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]