CB> However, for my ISAM tables, whenever I delete all the CB> records, the auto_increment number is reset. CB> Is there a reason for this in InnoDB? Is there a way that I CB> can reset the auto_increment number when all the records CB> are deleted? > try exec this query: > alter table <TABLE_NAME> auto_increment = 0;
hmm, that did the trick. But why must I do this manually? Does it have something to do with how the InnoDB tables/records are stored? Why isn't this done automatically as it is for MyISAM tables? Thanks for the info! 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
