/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 vote223 views1 answer
Set Mamp mysql globally
SQL
16 votes212 views3 answers
Delete row psql
SQL
0 vote233 views1 answer
How to run mysql in git bash
SQL
0 vote214 views1 answer
Mysql config slave
SQL
1 vote226 views1 answer
Sql count value greater than
SQL
0 vote207 views1 answer
Psql not found windows
SQL
2 votes226 views1 answer
Use cases condition in sql query laravel
SQL
0 vote254 views1 answer
For select oracle
SQL
1 vote217 views1 answer
How to update date add hours in postgresql
SQL
0 vote214 views1 answer
Database xml sql
SQL