delete command with auto increment

admin

Administrator
Staff member
Hello.

i have a table with 2 collums (id and body); id is auto incrementing and there are three rows in the table (see below):

ID BODY
1 some text...
2 some more text....
3 even more text.....

Now, lets say i delete the row with id 2, my table will now look like this:

ID BODY
1 some text...
3 even more text.....

The question is is there any way to "redo" the numbers in the ID collum so when i delete a row in the middle, the id of the row i deleted is reused?

For example, in the example above, i'd like the modified table to look like this:

ID BODY
1 some text...
2 even more text.....

?

Thanks in advance!
 
Back
Top