[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-db
Subject:    [PHP-DB] Re: Subject: Empty Table command?
From:       Neil Smth <php () comatose ! freeserve ! co ! uk>
Date:       2003-11-27 23:29:54
[Download RAW message or body]

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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[prev in list] [next in list] [prev in thread] [next in thread]