mysql - If I delete a row from a table in a database how to rename the primary keys

Question

So I want to delete a row from a table e.g

1

2

3

4

5

7

8

How do I rename the tables rows primary keys so they are equal to

1

2

3

4

5

6

7

Answer 1

This question comes frequently but it's a false problem. You don't have to care about id. It's just an identifier. Leave it as it is.

You can add a progressive number programmatically, using your favourite programming language or via sql.

select *,@row:=@row+1 as progressive_number
from table, (select @row:=0) as t