1)查找垃圾用戶(需要根據垃圾用戶的特征來判斷). select logintime,userid,sex from hfpet_member where sex='' order by logintime desc; delete from hfpet_member where sex='' and mid> 8000;
2)查找文檔微表中member id 不為空且member id 不是注冊用戶的文檔 文檔微表,用于一些輕量的查詢! select * from hfpet_arctiny where mid !='' and mid not in (select mid from hfpet_member) order by id asc;
3)查找沒有被審核,且member id 不為空且member id 不是注冊用戶的文檔 select title,mid,ismake from hfpet_archives where ismake='' and mid !='' and mid not in (select mid from hfpet_member);
4)查找沒有文檔id 的 addonarticle select * from hfpet_addonarticle where aid not in (select id from hfpet_archives);
刪除順序: delete from hfpet_member where sex='' and mid> 12000; delete from hfpet_arctiny where mid !='' and mid not in (select mid from hfpet_member); delete from hfpet_archives where ismake='' and mid !='' and mid not in (select mid from hfpet_member); delete from hfpet_addonarticle where aid not in (select id from hfpet_archives);