IDEA链接mySQL问题 : You have an error in your SQL syntax : 'OPTION SQL_SELECT_LIMIT=1000' (or 'OPTION SQL_SELECT_LIMIT=DEFAULT')

IDEA控制台错误信息:
check the manual that corresponds to your MySQL server version for the right
Code: 1064, SQL State: 42000] 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=1000' (也有'OPTION SQL_SELECT_LIMIT=DEFAULT'的情况)at line 1



问题解决过程:
根据“You have an error in your SQL syntax”、“your MySQL server version”更新mysql版本,无果;

查看pom.xml
<!-- 导入Mysql数据库链接jar包 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>${mysql-connector.version}</version>
<scope>runtime</scope>
</dependency>

根据“OPTION SQL_SELECT_LIMIT=1000(DEFAULT)”、网上资料将srm项目、ssm(Basic-Single-Module-SSM)项目更改 Database里的mysql驱动文件为 mysql-connector-java-5.1.21.jar成功。



后续待解决:
OPTION SQL_SELECT_LIMIT=1000(DEFAULT)有什么含义?
参考链接:
      https://stackoverflow.com/questions/15669270/option-sql-select-limit-default

Download Connector/J 链接:
      https://dev.mysql.com/downloads/connector/j/5.1.html
posted @ 2018-09-15 08:54  Daemonnnn  阅读(1188)  评论(0编辑  收藏  举报