Hi Guys,
I have created a database with a table names "bands". This contains a field called "Band_ID" The following data types are assigned to it: INT NOT NULL PRIMARY KEY AUTO_INCREMENT
My question is that when i manually delete a row within the Band_ID field, the next entry i put in has a higher number than the deleted row, it doesn't replace the deleted row, instead it gives it the next highest value.
Can anyone explain this and what do i do to fix it?
Cheers,
micmac
