row delete help

[KashKurcura]

what i am trying to do is delete all rows except for the last 20 rows, anyone know how this can be done?

basically i am keeping track of profile views so i know what members lasts seen who... my questin is how do i delete all but that last 2o for each $Member?

[bastien]

table structure? mysql version?

[KashKurcura]

hi, thanks for the reply.. here is the info that you requested.. please keep in mind that i need to do this for over 7000 members.

v 4.0.25

CREATE TABLE Profile_Views (
VistID int(7) NOT NULL auto_increment,
MemberID mediumint(7) NOT NULL default '0',
VisitorID mediumint(7) NOT NULL default '0',
DateTime datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (VistID),
KEY SP_Visits (MemberID,VisitorID)
) TYPE=MyISAM AUTO_INCREMENT=1339320 ;