How to assign unique id to existing rows?

Question

MySQL

There is a my_table table and an id column. The rows are already filled in it and all rows have id=0. How can I uniqueize all ids by giving them the value 1, 2, 3... and so on?

Answer 1

Solution:
We create a new column with type int, set AUTO_INCREMENT and Index "UNIQUE", after that we delete the old id column and rename the column we created to id.