|
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.
Navigation:
[Reply to this message]
|