<delete id="deleteBatchUserOfSp" parameterType="java.lang.String" >
delete from uauth.user
join uauth.usersp
on uauth.user.id = uauth.usersp.userid
where uauth.usersp.SPid = #{spid,jdbcType=VARCHAR}
</delete>
在做关联删除时这样的sql语句,mysql报错
<delete id="deleteBatchUserOfSp" parameterType="java.lang.String" > delete uauth.user from uauth.user join uauth.usersp on uauth.user.id = uauth.usersp.userid where uauth.usersp.SPid = #{spid,jdbcType=VARCHAR} </delete>
原来在delete后面必须指定表名
原文：http://www.cnblogs.com/vinozly/p/5004831.html