/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 vote170 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
1 vote97 views1 answer
How to open closed port mysql in ubuntu
SQL
1 vote113 views2 answers
Procedure syntax
SQL
0 vote118 views1 answer
Update sqlite
SQL
1 vote105 views3 answers
Reset sql primary key
SQL
8 votes115 views3 answers
SQL column name
SQL
0 vote102 views1 answer
Sql composite key
SQL
1 vote100 views1 answer
Does insert into overwrite sql
SQL
3 votes65 views1 answer
Ubuntu install postgresql 12
SQL
0 vote116 views1 answer
Drop database using terminal postgres
SQL