mysql delete join
文档说明:http://www.mysqltutorial.org/mysql-delete-join/
例子
delete d
from member_log d
left join member m ON d.uid=m.uid
where date(d.date)='2014' and m.uid is null ;
结构
member_log(id int auto_increment primary,`date` date,uid int): unique(date-uid)
member(uid int auto_increment primary)