Mybatis的xml文件中，一个方法中包含多条sql语句报错

报错如下：

Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delete from Table  where face_det_time <= DATE_SUB(CURDATE(), IN' at line 2

**

相关语句：

**

<delete id="deleteOverdueRecord" parameterType="java.lang.String" >
    delete from tableA where face_det_time &lt;= DATE_SUB(CURDATE(), INTERVAL #{interval} DAY);
    delete from tableB  where face_det_time &lt;= DATE_SUB(CURDATE(), INTERVAL #{interval} DAY);
  </delete>

解决方法：

数据源配置

添加 &allowMultiQueries=true

spring.datasource.druid.url=jdbc:mysql://192.168.2.41:3306/stm?useUnicode=true&characterEncoding=UTF-8&useSSL=false&allowMultiQueries=true