956
社区成员
发帖
与我相关
我的任务
分享
delete from bz_post_content WHERE ID IN (
SELECT a.id from bz_post a
left join bz_post_content c on a.id = c.id
where
a.id <>
(
select min(b.id) from bz_post b
left join bz_post_content d on b.id = d.id
where a.uid = b.uid and a.title = b.title and c.content = d.content
)
);
delete
from
bz_post_content t1
where exists(
select 1 from bz_post_content t2 where t1.uid=t2.uid and t1.title=t2.title and t1.content=t2.content and t2.id<t1.id
)