Posted by "Christian Ista" on 12/28/05 10:57

> From: William Stokes [mailto:kalles@operamail.com]
> I have one MySQL table with about 500 rows. I need to read the table one
> row at a time, make some changes to data in one field and then store the
> changed data to another table.

1. May be add a column, CHANGED_FL with default value N.
2. Select to find the ID minimum with a select CHANGED_FL is N
3. Select the row with the ID found above and make you business
4. Make change and change CHANGED_FL to Y

Repeat operation 2 to 4

C.

[Back to original message]