mysql select default,'OPTION SQL_SELECT_LIMIT = DEFAULT'

I have a mysql database on Netbeans and I want to see that view data but I have a error 1064 'OPTION SQL_SELECT_LIMIT=DEFAULT' . how can I fix ? thanks.

解决方案

Some google foo lead me to this:

That bug report sound pretty much like your problem - there is no good fix for

you. But there is a lead for some more reading.

The similarity to you problem:

It's also the jdbc driver involved

The error message is the same

the problem occurs on a very recent mysql server version

So I tried to find the problem in the mysql-connector-java sources and found

the statement in StatementImpl.java in version 5.1.18 - an older version can be

found here:

Look for "SET OPTION SQL_SELECT_LIMIT=DEFAULT" in the file and you will find

it.

I also checked the most recent version

I checked the source of mysql-connector-java 5.1.22 and the problem seems to be

fixed:

SET SQL_SELECT_LIMIT=DEFAULT

So suggested fix for the user: Please download the newer version of connector/j

and modify the driver entry in databases.

Suggested fix: Update bundled connector/j version