/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 vote273 views2 answers
How to check if sql query is correct online
SQL
0 vote264 views1 answer
Sql server whoami
SQL
0 vote310 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
13 votes272 views6 answers
Restart postgresql
SQL
0 vote276 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
15 votes262 views2 answers
How to know the username of postgresql
SQL
0 vote290 views1 answer
How to run mysql on terminal mac
SQL
0 vote294 views1 answer
Mysql trigger to delete old data
SQL
0 vote299 views1 answer
Insert using condition postgres
SQL
0 vote273 views1 answer
Add computed column to table sql server
SQL