How about updating all the fields instead of one?
UPDATE customers SET row_id=row_id+1000;
Regards,
Sebastiaan J.A. Kamp
VOF Post Zero
Hoogstraat 98a
3011PT Rotterdam
The Netherlands
----- Original Message -----
From: "Armando Cerna" <[EMAIL PROTECTED]>
To: <[EMAIL 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 ones stayed
> the same =(.
> Could someone please tell me the correct way to do this
>
> Armando
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php