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

List:       php-db
Subject:    Re[2]: [PHP-DB] Empty Table command?
From:       npguy <npguy () websurfer ! com ! np>
Date:       2003-11-28 3:57:36
[Download RAW message or body]

Hello Kim,

beside deleting, dropping any tips to do this very quickly

Friday, November 28, 2003, 1:37:20 AM, you wrote:

KS> As said yes, you just launch your old fashioned delete from statement,
KS> without
KS> any where clause, mySQL will interpret this as everything (which is infact
KS> what
KS> it does, it maches everything and therefor deletes everything).

KS> -- 
KS> Kim Steinhaug
KS> ---------------------------------------------------------------
KS> There are 10 types of people when it comes to binary numbers:
KS> those who understand them, and those who don't.
KS> ---------------------------------------------------------------


KS> "Rasmus Lerdorf" <rasmus@php.net> wrote in message
KS> news:Pine.WNT.4.56.0311262104180.3676@DELL...
>> delete from table_name
>>
>> On Wed, 26 Nov 2003, Chris Payne wrote:
>>
>> > Hi there everyone,
>> >
>> > Just a quick question which I can't for the life of me find the answer
KS> for on MySQL's website (Probably as i'm looking for the wrong term?) I want
KS> to know how to empty a table, is there an empty command or should I just
KS> tell it to delete everything?
>> >
>> > Chris




-- 
Best regards,
 npguy                            mailto:npguy@websurfer.com.np

-- 
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] 

Configure | About | News | Add a list | Sponsored by KoreLogic