Re: n00b deleting entries from db.

thx. "Dan Koken" <dkokenge@netscape.net> wrote in message news:3D4439D4.1060508@netscape.net... > > > Jj Harrison wrote: > > > I know how to delete stuff from a db. > > > > Now I want to delete all the earliest entires from the database except the > > latest 75 entries. > > > Is it easy or hard? > > > I would say easy.. > > > > I know about limit but it doesn't seem to work the other way. > > > Assuming you have nothing to associate your records with time of entry, > I agree LIMIT seems to be the easiest. > > If you have sub query try something like this. > DELETE from file limit (SELECT count(*) - 75, ',', count(*) from file) > > If no sub query you probably have to do it with 2 queries. One to get > the number of records and the other to substitute the variable > $num_records into the DELETE as > DELETE from file file limit $num_records - 75, $num_records > > > HTH Dan >