InnoDB and auto_increment fields

[Chris Boget]

sql, query (*sigh*, I hate this filter)

I have an auto_increment key set up on my InnoDB table.
Whenever I delete all the records, the number isn't reset.
However, for my ISAM tables, whenever I delete all the 
records, the auto_increment number is reset.
Is there a reason for this in InnoDB?  Is there a way that I
can reset the auto_increment number when all the records
are deleted?  I have a temporary table that has records
added and deleted all the time.  I wouldn't want the record 
number to eventually reach the ceiling for the datatype of 
the field.

Any insight would be greatly appreciated.

Chris