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: Wednesda
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
