MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=10'

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

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

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

You should just use SET SQL_SELECT_LIMIT=10; instead.

Look at the here.

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

You must Sign up as a member of Effecthub to view the content.