Quote:
Originally Posted by Salchester
So, how do records in a database usually get deleted? As the ID's for each record are going to have massive gaps in between the other records.
For example you would have the following if record ID 2,5,8 got deleted.
ID
1
3
4
6
7
9
10
How can this be stopped?
Many Thanks,
|
It can't and it shouldn't. MySQL keeps track of the records by it's own method using your ID value. It doesn't matter if the ID values are in a nice neat sequential list.