且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

错误代码1064,SQL状态42000:SQL语法有错误;

更新时间:2022-01-18 21:24:00

这看起来像是来自JDBC驱动程序的错误. JDBC驱动程序初始化连接时,它将向MySQL服务器发送多个命令,其中之一是:

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

问题是SET OPTION语法已被弃用一段时间,现在在MySQL 5.6中不再有效.这是来自MySQL错误数据库的相关错误对话:

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:

错误#66659:mysql 5.6.6m9在选项SQL_SELECT_LIMIT = DEFAULT上失败

尝试升级JDBC MySQL驱动程序.错误对话中列出了其他一些选项,以防无法升级驱动程序.

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