selecting/deleting all oldest entries in mysql.

Nasir Zubair lists at
Mon Mar 10 20:42:21 EST 2003

Hi all,

I need to create a small logger, for our work place, that will log staff's
IP addresses and host names. What I'm trying to do is to log last X accesses
to an online helpdesk, 24 for example. 

I'm having trouble coming up with a query to select/delete the oldest entry
when a X+1st entry,  (25th for the above number), is inserted.

Can anyone hint me on how to go about doing it?

- Nasir

More information about the talk mailing list