mysql delete join 

delete poster 
from theatre_poster poster
left join theatre a on theatre_id = a.id
where a.id is null
posted @ 2020-03-27 14:43  巴黎爱工作  阅读(3002)  评论(0)  编辑  收藏  举报