[KarlRoos]

Något som liknar detta bör lösa det:

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.