在'OPTION SQL_SELECT_LIMIT = 10'附近使用正确语法的MySQL服务器版本

I am posting this to save another dev hours of wasted time. Mysql release candidate 5.6.7-rc is junk. As as dev I usually follow as closely as possible with latest version. This caused me hours of debugging gerrit and mysql. The answer is to use a stable version. I hope this helps someone else.

我发布这个是为了节省另一个浪费时间的浪费时间。 Mysql发布候选版本5.6.7-rc是垃圾邮件。和dev一样,我通常会尽可能地跟随最新版本。这导致我花了几个小时调试gerrit和mysql。答案是使用稳定版本。我希望这有助于其他人。

Not sure on the SO protocol for doing something like this - so just posting as a question.

在SO协议上不确定做这样的事情 - 所以只是发布一个问题。

mysql> select VERSION();
+--------------+
| VERSION()    |
+--------------+
| 5.6.7-rc-log |
+--------------+
1 row in set (0.00 sec)

mysql> SET OPTION SQL_SELECT_LIMIT=10;
ERROR 1064 (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=10' at line 1


mysql>  select VERSION();
+------------+
| VERSION()  |
+------------+
| 5.5.28-log |
+------------+
1 row in set (0.00 sec)

mysql> SET OPTION SQL_SELECT_LIMIT=10;
Query OK, 0 rows affected (0.00 sec)

1 个解决方案

#1

Older versions of MySQL employed SET OPTION, but this syntax is deprecated in favor of SET without OPTION.

较早版本的MySQL使用了SET OPTION,但是这种语法不推荐使用SET而不使用OPTION。

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

不推荐使用SET OPTION语法,并在5.6版中将其删除。

You should just use SET SQL_SELECT_LIMIT=10; instead.

你应该只使用SET SQL_SELECT_LIMIT = 10;代替。

Look at the here.

看看这里。

Incompatible Change: The obsolete OPTION modifier for the SET statement has been removed.

不兼容的更改:已删除SET语句的过时OPTION修饰符。

#1