Posted by Jerry Stuckle on 12/18/58 11:50

cdtsly@relayeur.com wrote:
> in fact, i need this order because i am rebuilding a table and i need
> to do this way
>
> i have a workaround with generating no fetch of all the table, but to
> select the rows one by one
> which give a stupid number of query( 200 000 rows=>200 000 query) and
> it take a lot of time naturally :-)
>
> i made this example to show my problem
>
> is not there a possibility to fetch a special way which can take in
> consideration freshness?
>
>

No. Once rows are fetched, MySQL (or any other RDB) will not update an already
fetched value just because it has been updated. That's a big reason why you
shouldn't update tables while fetching data, unless you're updating the data you
just fetched.

P.S. Please don't top post.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]