in reply to Re^3: [OT] MySQL recalibrating a sort-index
in thread [OT] MySQL recalibrating a sort-index

>   and _t.new_number <> t.f_sort  --> avoid unnecessary writes

see "If you set a column to the value it currently has, MySQL notices this and does not update it."

Cheers Rolf
(addicted to the Perl Programming Language and ☆☆☆☆ :)
Wikisyntax for the Monastery