MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT’

最新推荐文章于 2024-07-26 03:47:23 发布

原创最新推荐文章于 2024-07-26 03:47:23 发布 · 6.9k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#SQL_SELECT_LIMIT #MYSQL报错 #JDBC driver #OPTION SQL_SELECT_LI

mysql 专栏收录该内容

9 篇文章

订阅专栏

本文解决了一个MySQL访问时出现的语法错误问题，该错误源于使用了过时的SET OPTION SQL_SELECT_LIMIT=DEFAULT命令。文章提供了更新JDBC驱动的具体步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

我在遇到了数据库访问时错误，具体如下：

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 'OPTION SQL_SELECT_LIMIT=26' at line 1

查了下之后类似OPTION SQL_SELECT_LIMIT=DEFAULT 都是一个mysql的BUG：

That looks like an error coming from a JDBC driver. When the JDBC driver initializes the connection, it sends several commands to the MySQL server, one of which is:

SET OPTION SQL_SELECT_LIMIT=DEFAULT

The problem is that the SET OPTION syntax has been deprecated for some time and is now no longer valid in MySQL 5.6. Here's a relevant bug conversation from MySQL's bug database:

Bug #66659: mysql 5.6.6m9 fails on OPTION SQL_SELECT_LIMIT=DEFAULT

Try upgrading your JDBC MySQL driver. The bug conversation lists some other options in case upgrading the driver is not an option.

具体问题链接：https://netbeans.org/bugzilla/show_bug.cgi?id=224260

解决办法：下载最新的JDBC驱动jar包替换你原来的jar包即可，链接如下：

http://dev.mysql.com/downloads/file.php?id=412737

见附件也可以