/SQL/Mysql update sequence with order by

Mysql update sequence with order by

SET @rank:=0;
update tablename
set fieldname =@rank:=@rank+1 ORDER BY fieldorder;

#OR

UPDATE tablename
JOIN (SELECT @rank := 0) r
SET fieldname=@rank:=@rank+1 ORDER BY fieldorder;

Similar codes

0 vote207 views1 answer
Where field is null sql knex
SQL
21 votes196 views4 answers
Oracle add column
SQL
0 vote187 views1 answer
Convert .mdf to .bak
SQL
7 votes185 views5 answers
Show details of table postgres
SQL
0 vote239 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote196 views1 answer
Sql comand for removing data from table
SQL
0 vote179 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
0 vote171 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
10 votes154 views2 answers
Sql where clause multiple values
SQL
0 vote188 views2 answers
Mysql get routine parameter list
SQL