Mysql + Mybatis Batch Update Datas Error: BadSqlGrammarException

The project updates data in batches. There is no problem with mybatis writing and SQL, and there is no problem with the data, but this error is reported.


The configuration of database URL needs to add a parameter allowMultiQueries:

url: jdbc:mysql://${ip}:${port}/${dbname}?allowMultiQueries=true

Read More: