大家好,又见面了,我是全栈君
CREATE TABLE tmp AS SELECT id FROM get_review_url WHERE (no,title,name,content) IN (SELECT no,title,name,content FROM get_review_url GROUP BY no,title,name,content HAVING
COUNT(*) > 1) AND id NOT IN (SELECT MIN(id) FROM get_review_url GROUP BY no,title,name,content HAVING COUNT(*)>1);
DELETE FROM get_review_url WHERE id IN (SELECT id FROM tmp);
DROP TABLE tmp;
版权声明:本文博客原创文章。博客,未经同意,不得转载。
发布者:全栈程序员栈长,转载请注明出处:https://javaforall.cn/117519.html原文链接:https://javaforall.cn