phpMyAdmin - autoincrementing ID

Quick question regarding phpMyAdmin and autoincrementing. If I add a product and it is assigned id 1, then I delete it before adding another, the next one is given the id 2 even though I deleted id 1. I hope th开发者_如何学编程is makes sense.

Does this matter?

No, this is normal (My)SQL behaviour.

Its not the way it works. The auto increment value is stored in a variable, and it only adds one to that, instead of checking the largest one and adding one to that. Its the normal behavior, it looks messy but it works fine.

Consider the example where you had 1000 rows, and deleted the row ID=1. Would you expect the next entry to be given an ID of 1001 ? or 1 ?

This is working as intended, though if you absolutely must, you can manually set the value just as you would any other column in MySQL.