多表联删

1. left join 方式：

DELETE b,p,pb,pby 要求表1(book) 要有值,其他表可以无值,都可以

FROM book b

LEFT OUTER JOIN print p

ON b.guid = p.book_guid

LEFT OUTER JOIN print_binding pb

ON p.guid = pb.print_guid

LEFT OUTER JOIN print_binding_year pby

ON pb.guid=pby.bind_guid

WHERE b.guid = ？

 

2. inner join 方式：要求所有的表都要求有数据, 关联的表一个表没数据,删除 0行

DELETE b,p,pb,pby

FROM book b

INNER JOIN print p

ON b.guid = p.book_guid

INNER JOIN print_binding pb

ON p.guid = pb.print_guid

INNER JOIN print_binding_year pby

ON pb.guid=pby.bind_guid

WHERE b.guid = ？