Tag Archives: IDEA Connect MYSQL Error

IDEA Connect MYSQL Error: You have an error in your SQL syntax : ‘OPTION SQL_SELECT_LIMIT=1000’ (or…

 

IDEA console error message.
    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



Problem solving process.
    Update mysql version according to "You have an error in your SQL syntax", "your MySQL server version", to no avail.

    Check the pom.xml
        <! -- Importing Mysql database link jar package -->
                <dependency>
                    <groupId>mysql</groupId>
                    <artifactId>mysql-connector-java</artifactId>
                    <version>${mysql-connector.version}</version>
                    <scope>runtime</scope>
                </dependency>

    According to "OPTION SQL_SELECT_LIMIT=1000 (DEFAULT)", the online information will be srm project, ssm (Basic-Single-Module-SSM) project to change the mysql driver file in Database to mysql-connector-java-5.1.21.jar successfully.