(1) Since the latest version of MySQL was updated to mysql5.6 in the previous period, the following error occurred in editing data when using MyEclipse DB browser:
(2) on-line check original is, because the MySQL drive jar version low caused by; previously used MySQL driver is Mysq-connector-java-5.0.8-bin.jar, we will be in development when the database is created when the test statement set is sent OPTION Sql_select_limit=default, you can see that the mysql5.6 version is no longer supporting the statement, so it will error. the driver can not keep up with the error;
(3) The workaround is simple, which is to update the driver's JAR program to the latest version:
To provide you with a free download the latest driver address:
Http://dev.mysql.com/doc/relnotes/connector-j/en/news-5-1.html
or My network disk: http://yunpan.cn/cA7GrYZPRVDx9 extract code ECBE
A status table for each version of the driver file is also found on the Internet.
MyEclipse using DB browser to connect to database error: OPTION Sql_select_limit=default