How to make something like this: v = 0 UPDATE FROM t SET `menuindex` = v++;?

Question

SQL

I have a table with a lot of data. I can sort it in the database, but I need to add the initial menu indexing, which will change over time.
v = 0 UPDATE FROM t SET `menuindex` = v++;
where v is an integer type
t is a table
as it is executed, the value will increase by 1.
Excuse: I don't know how to formulate a query in search engines...

Answer 1

What dialect of SQL?
For mysql: stackoverflow.com/questions/6617056/updating-colum...
For postgresql... However, by the characteristic ` in the column name, I think that you have mysql.

Answer 2

According to the link type such a solution:

SET @v := 0;
UPDATE FROM t SET `menuindex` = @v := @v+1;