Något som liknar detta bör lösa det:
Kod:
mysql> delimiter ;;
mysql> create trigger foo
-> after insert on entries
-> for each row
-> begin
-> DELETE FROM entries WHERE id < (SELECT min(id) FROM (SELECT id FROM entries ORDER BY id DESC LIMIT 50) AS myselect);
-> end
-> ;;
Observera att det är helt otestat.