有时我使用这个sql查询从我的posts表中删除重复的帖子。但它需要很长时间才能完成,让我的域名无法访问类似5分钟。看起来这对服务器来说是一个很重的sql,有没有办法让它变得更轻更快?SELECT a.post_id FROM ( SELECT post_title, post_id FROM hotaru_posts GROUP BY post_title ) a ) select post_id from hotaru_posts a group by post_title having count(
下面有两个表:create table lol2(id intauto_increment, data int, primary key id(id));insert into lol2 (data) values (1),(2),(3),(4);insert into lol (data) select data from l