Re: Changing auto_increment field in mysql to start at 1000

2001-08-29 Thread Sebastiaan J.A. Kamp
IL PROTECTED]> Sent: Wednesday, August 29, 2001 11:09 PM Subject: Changing auto_increment field in mysql to start at 1000 > > I tried this: > > update customers set row_id='1000' where row_id='1'; > > but that only changed the one field in the table and the other o

Re: Changing auto_increment field in mysql to start at 1000

2001-08-29 Thread Carl Troein
Armando Cerna writes: > update customers set row_id='1000' where row_id='1'; > > but that only changed the one field in the table and the other ones stayed > the same =(. Yes, that's the expected behavior when updating one field. Anything else would be a disaster. If what you're trying to d

Changing auto_increment field in mysql to start at 1000

2001-08-29 Thread Armando Cerna
I tried this: update customers set row_id='1000' where row_id='1'; but that only changed the one field in the table and the other ones stayed the same =(. Could someone please tell me the correct way to do this Armando -