从MySQL中的表中删除N个旧记录

从MySQL中的表中删除N个旧记录

我相信这会奏效…

DELETe FROM LoginTime WHERe id IN (     SELECT id     WHERe user_id = 1     ORDER BY datetime DESC     LIMIT 0, 5)