allowMultiQueries=true的作用

最新推荐文章于 2024-10-02 23:21:04 发布

替罪的羊

最新推荐文章于 2024-10-02 23:21:04 发布

阅读量1.6w

点赞数 10

分类专栏：小白学Java 文章标签：数据库 sql java Powered by 金山文档

本文链接：https://blog.csdn.net/weixin_53604412/article/details/128547177

版权

小白学Java 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

在MySQL连接中设置allowMultiQueries=true允许在SQL语句后使用分号分隔，执行多个命令。不设置此参数时，尝试执行多条SQL会引发SyntaxErrorException。添加该参数后，可以进行批处理操作，提高数据库操作效率。

摘要由CSDN通过智能技术生成

MySQL连接数据库时，添加语句：“allowMultiQueries=true”的作用：

1.可以在sql语句后携带分号，实现多语句执行。

可以执行批处理，同时发出多个SQL语句。

sql语句

不加allowMultiQueries=true之前，会报错

org.springframework.jdbc.BadSqlGrammarException: 
### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '=ticket-1 where id = 1
         ; 
            update  ticket ticket=ticket-1 wh' at line 1
### The error may exist in file [F:\test\my1\target\classes\mapper\TicketMapper..xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: update  ticket ticket=ticket-1 where id = ?          ;              update  ticket ticket=ticket-1 where id = ?
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '=ticket-1 where id = 1
         ; 
            update  ticket ticket=ticket-1 wh' at line 1
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '=ticket-1 where id = 1
         ; 
            update  ticket ticket=ticket-1 wh' at line 1

加了之后