Hi, I would like to find a magic query! I whish I could have a query in mySQL that will delete all record except the last 5 entered. All record entered are timestamp. The problem, I have no clue where to start for such a query.

DELETE FROM Previous_Login WHERE User_Id=1 ORDER BY LastConnect LIMIT 5,50;

The LIMIT clause work on the DELETE command, but with only one argument. EX :

DELETE FROM Previous_Login WHERE User_Id=1 ORDER BY LastConnect LIMIT 5;

____________________________
A Stick give a wise man something to think about... and a fool, something to put in is mouth.

I did do a work arround :

<?php $sql = "SELECT Id FROM Previous_Login WHERE User_Id=$Id"; $result = $this->db->query($sql); If ($result->size() > 5) {     $sql = "DELETE FROM Previous_Login WHERE User_Id=$Id ORDER BY LastConnect LIMIT 1";     $result = $this->db->query($sql); } ?>

But I have to do 2 query insteed of one, which is not a efficient.

____________________________
A Stick give a wise man something to think about... and a fool, something to put in is mouth.