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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> To: Chris Payne <[EMAIL PROTECTED]> cc: [EMAIL PROTECTED] Message-ID: <[EMAIL PROTECTED]> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Subject: Re: [PHP-DB] Empty Table command?
delete from table_name
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php