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]
