/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 vote298 views1 answer
Enable sql server full text indexing
SQL
0 vote306 views1 answer
Prodection ready postgres database step by step
SQL
0 vote281 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
0 vote287 views2 answers
Postgres another version
SQL
5 votes306 views4 answers
Restart the psql server windows
SQL
0 vote298 views1 answer
Apache Derby: Create SQL Dump with data
SQL
0 vote275 views1 answer
Postgres select except
SQL
6 votes290 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
2 votes312 views1 answer
Sql server find columns list in tables
SQL
2 votes314 views1 answer
Coalesce sql
SQL