Auto Increment - Deletion

[jaymc]

I have my ID field set up as auto increment

Now, lets say I have the following in a database in the ID field

1
2
3
4

If I delete record 4, that means I will be left with

1
2
3

However, and here is my problem. When a new record is added, it auto increments the ID field to 5. Obviously their is some kind of counter which still holds 4 as the last number.

Is their anyway around this without querying the database?

[fenway]

Any way around what?  What are you using this field for that it matters?

[jaymc]

Song ID's.

In other words, I want it to auto increment from the last ID in the table

[AndyB]

Treat auto-incrementing fields as if they belong to MySQL (which they do) and you can't mess with them, instead of something that's yours.  You'll be glad you did when you want to use ids from different tables to do some cross-referencing.