Re: Empty Table command?
| From: | Kim Steinhaug | Date: | Thu, 27 Nov 2003 19:52:20 +0000 |
| Subject: | Re: Empty Table command? | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31797@lists.php.net to get a copy of this message | ||
As said yes, you just launch your old fashioned delete from statement,
without
any where clause, mySQL will interpret this as everything (which is infact
what
it does, it maches everything and therefor deletes everything).
--
Kim Steinhaug
---------------------------------------------------------------
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't.
---------------------------------------------------------------
"Rasmus Lerdorf" <rasmus@php.net> wrote in message
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
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