mysql delete join 写法

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)