delete from ut_consign where sale_id = userid order by time asc limit 2
delete from ut_consign where (select from ut_consign where sale_id = %q order by time desc limit 10 )
...全文
1094打赏收藏
请教一个限制条件的删除语句的问题
我想删除按时间排序后,排在20条记录之前的老记录,用下面的语句都有问题,不知道是哪儿有问题? 第一条 执行有警告,在程序里直接报错。第二条是直接的语法错误 delete from ut_consign where sale_id = userid order by time asc limit 2 delete from ut_consign where (select from ut_consign where sale_id = %q order by time desc limit 10
那就把要删的id放到临时表里
create table tmp(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);