Next Auto Index

[sfullman]

Here's probably a simple question:

I set up a table with an autoincrement field, let's call it ID.

As I understand it, the "Next Auto Index" will always be incremented. So for example, if I have 100 records, the next auto increment is going to be 101. That DOESN'T CHANGE if I delete 50 of the records, the auto-index is NOT going to be 51. This is a good thing I think.

However, how can I query mysql for the next auto index value scheduled for that table? I think it can be done because phpMyAdmin lists that for the page structure.

Thanks for a quick courteous response.
Sam Fullman

[mrhappiness]

SHOW TABLE STATUS LIKE 'tablename'

HTH