/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 vote316 views1 answer
Tsql random number
SQL
7 votes376 views2 answers
Sql remove duplicates based on column
SQL
0 vote316 views1 answer
Postgresql isnull with max
SQL
21 votes332 views1 answer
Cheatsheet for sql
SQL
0 vote306 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote346 views1 answer
Uncheck constraints and delete from table
SQL
18 votes329 views6 answers
Drop table if exists
SQL
0 vote312 views1 answer
Renommer schema sql
SQL
0 vote311 views1 answer
Get time component of datetime sql
SQL
3 votes331 views1 answer
Select database in sql
SQL