/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 vote181 views1 answer
Full sql mode
SQL
2 votes200 views3 answers
Mysql kill
SQL
0 vote171 views1 answer
Access refused mysql xampp server
SQL
0 vote194 views2 answers
Dbms interview questions
SQL
0 vote194 views1 answer
Day of the week sqlite
SQL
0 vote193 views1 answer
Mysql convert charset
SQL
0 vote170 views1 answer
Inser into example
SQL
0 vote178 views1 answer
Java spring boot connect to sql server
SQL
9 votes170 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
1 vote197 views1 answer
Group_concat max length mysql
SQL