MySQL doesn‘t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery‘

经常写Oracle，对于MySQL写法有点差异
/*
select * from actionexecutelog where id not in (
SELECT id FROM actionexecutelog order by id desc limit 10)
*/–这会报错MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery’

以下写法仅供参考
1：select * from actionexecutelog where id not in (
select t.id from (
SELECT id FROM actionexecutelog order by id desc limit 10) as t);

2：select * from actionexecutelog a ,(select id from actionexecutelog order by id desc limit 9,1) as b where a.id<b.id;