While using DB toolbox database explorer I consistently get an error message to check the MySQL manual for syntax to use near ‘OPTION SQL_SELECT_LIMIT=25’ at line 1?

I am using MySQL and the JDBC driver.

The full text of the error message is:

You have and 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=25' at line 1

I can establish connections and run queries from the command line. The issue relates to using the database explorer. The error is recent, as the explorer interface worked until recently. I've made a few updates in my environment, but cannot recall the specific event, if any, that triggered the issue.

Answer 1

[Piyush Kumar]

@Blake Brazil,

If you are using "SET OPTION SQL_SELECT_LIMIT=25;", there is an issue with the syntax.

"SET OPTION" syntax is deprecated, and was removed in version 5.6.

You should just use "SET SQL_SELECT_LIMIT=25;" instead.

Check this stackoverflow answer.