I'm getting some weird results in my database queries. Here's the situation: I have a little script (php) that adds information to the database.. the database contains a bunch of columns, and then an 'id' column which is the index, primary key, unique, and auto_incrementing column.
The first record's id is 1. I was adding and deleting records to do some tests, except for record 1, and the id column kept incrementing. I added records all the way up to id 15, and then deleted id's 2 through 15, so only 1 was remaining.
But now, when I add new records, they start at 16, instead of starting at 2. When I delete 16, the next record goes to 17, and 18, and so on.
It's almost like mysql knows that I've already put a record in with that id, and even if I delete that record, it increments the id above that number.
How do I reset this sort of strange cache so that I can make the second entry id 2 again? I need my records to be in 1, 2, 3 id order because of the way the php script manages the data pulled from the database.
Thanks in advance.
