MySQL中使用LEFT JOIN后执行delete删除操作
DELETE a FROM task_news a LEFT JOIN temp_new b ON a.ID = b.ID WHERE b.UserID > 0
JOIN之后根据关联删除多个表的数据
DELETE t1, t2, t3 FROM table1 t1 LEFT JOIN table2 t2 ON t2.fkey_id = t1.id LEFT JOIN table3 t3 ON t3.fkey_id = t1.id WHERE t1.id = "value";