Re: n00b deleting entries from db.
| From: | Jason Wong | Date: | Sun, 28 Jul 2002 17:47:23 +0000 |
| Subject: | Re: n00b deleting entries from db. | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20845@lists.php.net to get a copy of this message | ||
On Sunday 28 July 2002 17:37, JJ Harrison wrote:
> I know how to delete stuff from a db.
DELETE FROM table WHERE something_or_another
> Now I want to delete all the earliest entires from the database except the
> latest 75 entries.
How do you define 'earliest' and 'latest'? Do you have a date/time associated
with each record? If so use it the WHERE clause above.
> Is it easy or hard?
Depends on how long the piece of string is :)
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
Old age is the most unexpected of things that can happen to a man.
-- Trotsky
*/