On Sep 7, 2:36*pm, Max Kanat-Alexander wrote:
> On 09/06/2009 11:07 PM, CHOE Wai Marn wrote:
>
> > After our import (of those bugs with 9000+ number, say 2 bugs 9001 and
> > 9002), and we have set the AUTO_INCREMENT to 1050. However, the next bug
> > will take the bug number 9003 (since in the database, 9002 is the largest).
> > Is there anyway to let the bug numbers stay put in the 1000+ number? (i..e.
> > back to 1050, 1051 and onwards).

>
> * * * * Just change the AUTO_INCREMENT again. However, you will hit problems
> when you get to bug 9000 again, and will have to properly re-set the
> AUTO_INCREMENT after that.
>
> > Subsequently, Site A added more info to those imported bugs and we needto
> > populate the same bugs back to Site B (this is where we are still trying to
> > figure what's the best method to do this, and bug numbers shall remain the
> > same...)

>
> * * * * Why are you copying bugs that are still being updated?
>
> * * * * -Max
> --http://www.everythingsolved.com/
> Competent, Friendly Bugzilla and Perl Services. Everything Else, too.


I have set the auto_increment number to 1050 using below command.

ALTER TABLE tbl AUTO_INCREMENT = 1050;

But when new bug created or imported, bug number still will take the
largest which is 9003 but not 1050.

Above method work when 1050 is the largest number in the bug number
field.