You have an error in your SQL syntax; check the man第二次出现这个问题了,语句放mysql里执行没问题.在springboot里执行报错..乜有语法问题.也报语法问题.

You have an error in your SQL syntax; check the man第二次出现这个问题了,语句放mysql里执行没问题.在springboot里执行报错..乜有语法问题.也报语法问题.最后发现是使用了多个一次执行多个条语句没有加数据库参数:allowMultiQueries=true

以后不能自己写数据库url链接了.备份一下收藏的参数:

jdbc:mysql://127.0.0.1:3306/nacos?characterEncoding=utf8&connectTimeout=1000&socketTimeout=3000&autoReconnect=true&useUnicode=true&useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&allowMultiQueries=true&zeroDateTimeBehavior=convertToNull&nullCatalogMeansCurrent=true&useLegacyDatetimeCode=false&useJDBCCompliantTimezoneShift=true

发生系统错误:

### Error querying database.  Cause: 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 'set @NotPublishCount := 0; 

        set @equipmentWaitFollowCount := 0;' at line 2

### The error may exist in file [123456.xml]

### The error may involve defaultParameterMap

### The error occurred while setting parameters

### The error may exist in file [123.xml]

### The error may involve defaultParameterMap

### The error occurred while setting parameters

### SQL: