在mapper.xml中根据一个ID删除多张表

<delete id="deleteWork">
    DELETE FROM a WHERE ID=#{id};
    DELETE FROM b WHERE WORK_ID=#{id};
    DELETE FROM c WHERE WORK_ID=#{id};
    DELETE FROM d WHERE WORK_ID=#{id};
    DELETE FROM e WHERE WORK_ID=#{id};
</delete>

此方法我尝试过，在Navicat中，直接执行是可行的，放入到xml中回抛出异常；于是替换为以下方式，执行程序正常。

<delete id="deleteWorkCircle">
        DELETE a,b,c,d,e
        FROM
            work_circle a
            LEFT JOIN circle_image b ON a.ID = b.WORK_ID
            LEFT JOIN circle_discuss c ON a.ID = c.WORK_ID
            LEFT JOIN circle_like d ON a.ID = d.WORK_ID
            LEFT JOIN circle_view e ON a.ID = e.WORK_ID
        WHERE
            a.ID = #{id};
</delete>