MySQL: Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘OPTION SQL_SELECT_LIMIT=100’ at line 1

Scenario:
This is the first time you are exactly calling that particular MySQL database and you are getting the following error message from your database client or IDE:

"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=100' at line 1"

Solution:
If so, you are in luck as the issue can be as simple as updating your MySQL jar. Yup most likely your jar is outdated.
Click here to update your jar now.

One thought on “MySQL: Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘OPTION SQL_SELECT_LIMIT=100’ at line 1”

Leave a Reply

Your email address will not be published. Required fields are marked *