update column by row number

Question

hello All,

I have one table that contain lots of record and i want to upadte my primary key by row number . My database => MYSQL

Answer 1

You shouldn't do that.
There is not a thing called "row number" in the database.
Such a number can be applicable only to output of certainly ordered and filtered data, but not to stored one.

Leave your primary key alone, it identifies the whole record, not it's "position" (especially because there is no position at all).

Why do you need that? Your task has another solution for sure, a proper one

Answer 2

mysql isnt oracle and doesnt support rownum