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. Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.