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@xxxxxxxxxxxxxxxxx> To: <php-db@xxxxxxxxxxxxx> 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@xxxxxxx> To: Chris Payne <chris@xxxxxxxxxxxxxxxxx> cc: php-db@xxxxxxxxxxxxx Message-ID: <Pine.WNT.4.56.0311262104180.3676@DELL> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Subject: Re: Empty Table command?
delete from table_name
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
