RE: [PHP] SELECT?
| From: | Christian Ista | Date: | Wed, 28 Dec 2005 08:57:27 +0000 |
| Subject: | RE: [PHP] SELECT? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-227914@lists.php.net to get a copy of this message | ||
> 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.