ALTER TABLE MyTable AUTO_INCREMENT = 56; On Mon, Nov 3, 2008 at 7:59 AM, Fogelson, Steve <[EMAIL PROTECTED]>wrote:
> I have a table that has the table id set to auto increment. I have 3 > records that the id is set to 99997, 99998, 99999 and the largest id beneath > that is 55. When I add a new record the id is set to100000. Is there a way I > can have it set to 56 instead? In the other DB I was using, each auto > increment field had a counter and this wasn't a problem. > > Thanks > > Steve Fogelson > Internet Commerce Solutions > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
