/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 vote173 views1 answer
Example database query
SQL
0 vote133 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote123 views1 answer
1 column values in to 1 single row in sql
SQL
4 votes134 views1 answer
Id increment ms sql server
SQL
0 vote117 views1 answer
Call function in query sql server
SQL
3 votes145 views1 answer
Oracle function return
SQL
0 vote131 views1 answer
Drop all procedures sql server
SQL
0 vote177 views1 answer
Add week ending date sql server
SQL
1 vote134 views1 answer
Name of today sql
SQL
4 votes212 views1 answer
What are the data types
SQL