Weil ichs gerade für ein TYPO3 Flow Projekt brauchte… 🙂 Notiz an mich:
How to update a MySQL column with ascending numbers
Given the problem you have a new column postion and that column should be updated for all existing rows with ascending numbers. Furthermore these numbers should be generated by a special order. In order to achieve that you could do the following:
SET @pos := 0; UPDATE pages SET position = ( SELECT @pos := @pos + 1 ) ORDER BY updated_at DESC;
Quelle: How to update a MySQL column with ascending numbers – makandropedia