mybatis在＜delete＞标签中实现执行多条删除语句

1. 在项目配置中数据库连接参数加上allowMultiQueries=true（开启批量执行sql参数的意思）；

url: jdbc:mysql://localhost:3306/bi_meta?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&useSSL=false&allowMultiQueries=true

2. 在<delete>标签中写多条语句，用；隔开

<delete id="UserDeletePower">
    DELETE
    FROM tableone
    WHERE userid = #{userid};
    DELETE
    FROM tabletwo
    WHERE userid = #{userid};
</delete>