----- Original Message ----- > From: "Steven Staples" <sstap...@mnsi.net>
You're asking the wrong question, though. WHY do you want to do that? You should never, ever ever rely on auto_increment for stuff like record insert order. Did I mention NEVER? Autoincrements can get reset for a variety of reasons. The only thing you should use them for, is for having a cheap guaranteed-unique record identifier. No point whatsoever in trying to compact them, and in larger databases where you depend on them for reference to other tables, it becomes an absolute nightmare to do so. Whatever you're up to, there's a better way to do it. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql