/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

3 votes341 views1 answer
Sql online test questions and answers
SQL
4 votes333 views1 answer
Is there any command to change postgres password
SQL
1 vote344 views1 answer
Right outer vs left outer join
SQL
3 votes311 views1 answer
What is having clause
SQL
2 votes357 views3 answers
Postgres create view
SQL
2 votes345 views1 answer
How to delete all duplicate items in mysql
SQL
0 vote354 views1 answer
Pgsql is not permitted to log in
SQL
1 vote354 views1 answer
Postgresql escape single quote
SQL
0 vote344 views1 answer
Sql tablo hangi sp de
SQL
9 votes324 views3 answers
Sequence postgresql
SQL