MySQL Spalten updaten: Werte aufsteigend setzen.

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

MySQL „Search & Replace“

Fatal error: Uncaught Error: Call to a member function id() on array in /home/laufedbk/ Stack trace: #0 /home/laufedbk/ CrayonFormatter::format_code('', Array, Object(CrayonHighlighter)) #1 [internal function]: CrayonFormatter::delim_to_internal(Array) #2 /home/laufedbk/ preg_replace_callback('#()#msi', 'CrayonFormatter...', 'update mein_tab...') #3 /home/laufedbk/ CrayonFormatter::format_mixed_code('update mein_tab...', Object(CrayonLang), Object(CrayonHighlighter)) #4 /home/laufedbk/ CrayonHighlighter->process() #5 /home/laufedb in /home/laufedbk/ on line 36