At 11/02/2002 05:21, Paul DuBois wrote: >At 4:10 +0700 2/11/02, Steven Haryanto wrote: >>i believe since 3.23.39 it should not be? > >BDB and MyISAM tables have different properties with respect to >AUTO_INCREMENT behavior.
i see, so this is an "undocumented feature" (i haven't seen this in http://www.mysql.com/doc/B/D/BDB_characteristics.html , for example). any idea how i can get non-recycling auto_increment field with bdb table (aside from having to maintain another "dummy" myisam table to generate non-recycling sequence for it)? -- sh --------------------------------------------------------------------- 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