【MySql】常用sql语句

1. 除最新n条数据之外，其他数据均删除

delete from expire_prompt
where id not in 
(select id from (select id from expire_prompt ORDER BY id desc limit #{saveRecordsNum}) as t1)

多加个select的原因是内层select语句不能带有limit语句，只能把它看作表来查，记得加别名才行。