selecting/deleting all oldest entries in mysql.
lists at ny-tech.net
Mon Mar 10 20:42:21 EST 2003
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?
More information about the talk