/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

-2 votes374 views1 answer
How-to-remove-mysql-root-password
SQL
1 vote363 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
0 vote344 views1 answer
Google cloud sql postgres url example
SQL
-1 vote357 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
6 votes356 views2 answers
Database url postgres
SQL
0 vote376 views2 answers
Mysql calcular idade
SQL
0 vote360 views1 answer
Create bdd mysql
SQL
0 vote435 views1 answer
How to check common records in 2 table
SQL
0 vote326 views1 answer
How to export table data from mysql table in sql format
SQL
0 vote341 views1 answer
Postgresql conectar
SQL