/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

7 votes185 views3 answers
Sql get last inserted row
SQL
4 votes235 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote311 views1 answer
Sql alchemy escape ; in insert statement
SQL
0 vote187 views1 answer
Create a view in sqlite
SQL
0 vote187 views1 answer
How to reset AI in sql
SQL
1 vote211 views1 answer
Mysql size int
SQL
0 vote217 views1 answer
How to print sql query
SQL
1 vote252 views1 answer
How to put value in variable mysql
SQL
5 votes190 views1 answer
Ignore duplicate rows in sqlite
SQL
58 votes569 views4 answers
Mysql drop column
SQL