Re: Subject: Empty Table command?

TRUNCATE TABLE tablename in MySQL is much faster (to return) than DELETE FROM since it doesn't log the deletes, it just writes a zero marker to the file. (Hehe, Rasmus knows better than that too ! Must be having an off-day there !) Cheers, Neil. At 12:38 27/11/2003 +0000, you wrote:

From: "Chris Payne" <chris@planetoxygene.com> To: <php-db@lists.php.net> Date: Wed, 26 Nov 2003 23:42:11 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative;

        boundary="----=_NextPart_000_0007_01C3B476.E9C04B60"

Subject: Empty Table command? Hi there everyone, Just a quick question which I can't for the life of me find the answer for on MySQL's website (Probably as i'm looking for the wrong term?) I want to know how to empty a table, is there an empty command or should I just tell it to delete everything? Chris Date: Wed, 26 Nov 2003 21:04:26 -0800 (Pacific Standard Time) From: Rasmus Lerdorf <rasmus@php.net> To: Chris Payne <chris@planetoxygene.com> cc: php-db@lists.php.net Message-ID: <Pine.WNT.4.56.0311262104180.3676@DELL> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Subject: Re: [PHP-DB] Empty Table command? delete from table_name