/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

1 vote325 views1 answer
Mysql curdate between two dates
SQL
0 vote331 views2 answers
Execute stored procedure without db set
SQL
1 vote291 views1 answer
Column with prefix in sql
SQL
3 votes328 views1 answer
Postgres select max value
SQL
2 votes314 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote300 views2 answers
T SQl Checking Your Username
SQL
2 votes323 views1 answer
Datetrunc
SQL
0 vote335 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
10 votes303 views4 answers
Sql pagination
SQL
1 vote258 views1 answer
Postgres kill pid
SQL