Germaris Posted December 31, 2006 Share Posted December 31, 2006 Hi there!my_table has 23043 records.The next autoindex indicates 23047.I have verified the largest index value allocated which is 23046 and which is correct.How can I find the two index values which aren't used?(so I can use them with new records and therefore have the index values and the number of records having the same value : 23046).Many thanks in advance for your help. Link to comment https://forums.phpfreaks.com/topic/32401-missing-index-values/ Share on other sites More sharing options...
wildteen88 Posted December 31, 2006 Share Posted December 31, 2006 Did you delete any rows with the id of 23044 to 23046? If you did then thats why. autoindex has an internal counter and does not reuses previously used ids. This is the proper behaviour of auto_increment. Link to comment https://forums.phpfreaks.com/topic/32401-missing-index-values/#findComment-150512 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.