/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 vote273 views1 answer
Check user sql password from command line
SQL
3 votes266 views1 answer
Oracle list user grants
SQL
0 vote264 views1 answer
Sql delete from with relation
SQL
15 votes246 views2 answers
Sql order by multiple columns
SQL
3 votes269 views1 answer
Oracle transaction commit rollback example
SQL
0 vote262 views2 answers
Sql query inner join 3 tables
SQL
2 votes257 views1 answer
How to show the whole table in sql
SQL
0 vote266 views1 answer
Postgres grep entire database
SQL
8 votes263 views3 answers
Oracle auto_increment
SQL
0 vote242 views1 answer
List MySQL Table and Index Size
SQL