在插入请求上自动从SQL表中删除旧记录

Question

I'm looking for a solution to auto-remove the oldest record of a table when a new record is inserted :

I want maximum 3 different records with different data but same userID, and I would like to make my table automatically remove the oldest record when a new one is inserted.

I think it's clear enough to be understood.. If not, I'll try to explain. Sorry for bad english, not my main language

Thanks

Answer 1

Could you try this kind of request ?

delete 
from table_name 
where id not in ( 
    select id 
    from table_name 
    order by timestamp_column desc 
    limit 0,3
)