第一条语法是没有错误
修改第二条
delete from ut_consign where sale_id in (select sale_id from ut_consign where sale_id = %q order by time desc limit 10 )
修改第二条
delete from ut_consign where sale_id in (select sale_id from ut_consign where sale_id = %q order by time desc limit 10 )
提示
this version of mysql doesn't yet support `limit`&in/all/any/some subquery
我用的是heidi sql 最新的8.1版
delete a from tt a inner join
(select sale_id from tt where sale_id = userid order by time asc limit 2) b
on a.sale_id=b.sale_id
select from ut_consign where sale_id = %q order by time desc limit 10;delete from ut_consign where sale_id in(slect id from tmp);