IDEA链接mySql问题 : You have an error in your SQL syntax : 'OPTION SQL_SELECT_LIMIT=1000' （or 'OPTION ...

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

转载于:https://www.cnblogs.com/daemonFlY/p/9820465.html