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!
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!