Re[2]: [PHP-DB] Empty Table command?
| From: | npguy | Date: | Fri, 28 Nov 2003 03:39:36 +0000 |
| Subject: | Re[2]: [PHP-DB] Empty Table command? | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31799@lists.php.net to get a copy of this message | ||
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