DECLARE @Count INT = 1
WHILE @Count > 0
BEGIN
DELETE TB FROM TableName TB
WHERE TB.ID IN (SELECT MIN(ID) FROM TableName TB2
GROUP BY TB2.Column1,TB2.Column2,...TB2.ColumnN
HAVING COUNT(1) > 1...
Mysql每天执行计划,保留最新的10条数据,其余的删除
1、Mysql 保留最新的10条数据
sql语句:
DELETE tb FROM tbname AS tb,(
SELECT id FROM tbname ORDER BY id desc LIMIT 9,1
) AS tmp
WHERE tb.id<tmp.id...
delete from `jb_postcontent` where id not in(select min(id) from (select * from `jb_postcontent`) as t group by t.id);
网上搜索的大部分都是如下这样
delete from people
where peopleId in (select peop...