sql中需要加上分号,表示一天sql语句的结束:
<delete id="deleteBussinessData" statementType="STATEMENT"> <foreach collection="tableList" item="tableName" index="index" > delete from ${tableName} where company_id = ${companyId}; </foreach> </delete>
2024-04-05 15:20:12
sql中需要加上分号,表示一天sql语句的结束:
<delete id="deleteBussinessData" statementType="STATEMENT"> <foreach collection="tableList" item="tableName" index="index" > delete from ${tableName} where company_id = ${companyId}; </foreach> </delete>