删除discuz90天未活动会员的sql

delete cdb_members , cdb_memberfields from cdb_members , cdb_memberfields where cdb_members.lastvisit+90*86400< UNIX_TIMESTAMP() and cdb_memberfields.uid=cdb_members.uid; [error]



delete cdb_members , cdb_memberfields  from cdb_members , cdb_memberfields 
where
cdb_members.lastactivity+90*86400<UNIX_TIMESTAMP()
or (cdb_members.lastactivity+90*86400<=UNIX_TIMESTAMP() and cdb_members.lastactivity>0)
and cdb_memberfields.uid=cdb_members.uid;[right]
Posted on 2007-03-21 17:51  古代  阅读(267)  评论(0)  编辑  收藏  举报