this is on Linux version of MySQL Query Browser. I need the same on Win
version. But, there is no such a solution (Tool > Option > ...).
> I'm assuming you're talking about the Mysql Query Browser?
> You can change the number of records under Tools-> Preferences and
> changing the "Max Rows For Generated Queries" to whatever you want, set
> to zero removes the limit entirely.
> On Sat, 2007-12-01 at 15:17 -0600, Afan Pasalic wrote:
>> on Linux version of MySQL Browser (v 1.2.4 beta), when double-click on
>> any table, default query is
>> SELECT * FROM <table_name> LIMIT 0,1000
>> On Win version (v 1.2.9 rc), there is no LIMIT part - what caused me to
>> pull so many times tens, even hundreds thousands of records.
>> I was looking for in setting for this feature, but wasn't able to find.
>> is there way to set the limit value on default select query, on win version?
>> thanks for any help.