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 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php