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?

2 次查看（过去 30 天）
Blake Brazil
Blake Brazil 2013-12-1
回答： Piyush Kumar 2024-9-30
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.

请先登录，再回答此问题。

回答（1 个）

Piyush Kumar
Piyush Kumar 2024-9-30
@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.

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by