/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 vote351 views1 answer
Select count distinct multiple columns sql server
SQL
1 vote390 views1 answer
Find size of all DB's postgres
SQL
0 vote333 views1 answer
Psql not found windows
SQL
0 vote357 views1 answer
Oracle query to find schema you are working on
SQL
0 vote337 views1 answer
A network or instance-specific error sql server
SQL
0 vote338 views1 answer
Pip install mysqlclient error
SQL
0 vote344 views1 answer
Tsql find procedure with name
SQL
0 vote345 views1 answer
Get the previous column of a table in mysql
SQL
6 votes358 views2 answers
Postgresql pg_dump
SQL
0 vote375 views1 answer
Mysql default tls v1.3 ciphersuites
SQL