/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

4 votes1.2K views1 answer
Oracle show errors
SQL
15 votes352 views6 answers
Drop foreign key mysql
SQL
3 votes420 views2 answers
Savepoint in sql
SQL
16 votes383 views3 answers
Update table from another table
SQL
3 votes345 views1 answer
Make a field auto_increment mysql
SQL
15 votes353 views3 answers
Find duplicate keys in mysql
SQL
4 votes365 views2 answers
How to insert ip address in mysql using php
SQL
0 vote364 views1 answer
Update view sql
SQL
24 votes337 views5 answers
Sql reset auto increment
SQL
0 vote402 views1 answer
How to check rollback status in oracle
SQL