On Wed, 27 Aug 2003 10:04:02 -0400 Paul DuBois <[EMAIL PROTECTED]> wrote:
> Second reason still applies. yes, but I suppose he knows what he's trying to do =) > If it's still something deemed desireable: > > ALTER TABLE tbl_name AUTO_INCREMENT = 1; yes, this is another one possible solution, but I think that DELETE FROM table; ALTER TABLE table AUTO_INCREMENT = 1; is not so pretty, as TRUNCATE TABLE table; and is not so efficient. am I wrong? > (or 0, but sequences don't really begin with 0, they begin with 1. :-)) yep =) but we both know what he's talking about... it's a some kind of telepathy =)) --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]