How to get AUTO_INCREMENT value?

[tim_kinder]

Hello,

I want to get AUTO_INCREMENT value from a table; I can do it if there are records in the table (just read the max. id) - but what to do if the table is empty (but AUTO_INCREMENT is greater than 0)?

Sincerely,

Tim Kinder

[russell]

what db?

[tim_kinder]

Sorry, I did not mention it - MySQL 3.23

The bigger task is to create an empty table (like original one) and continue to write there with ID's bigger than last one in the original table.

[cridley]

Why you creating a new table if old one is empty anyway?
One not terribly good solution would be to insert a row, get the id with mysql_insert_id then delete the row and your next id will be that+1 ... Not ideal, there's prob a simple way to get the value your looking for...