Hi,
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.

-afan

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:
> Hi,
> 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.
>
> -afan
>

hi barry,
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 > ...).


-afan



barry wrote:
> 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:
>> Hi,
>> 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.
>>
>> -afan
>>
>
>

I'm talking about the Linux (ubuntu) version.

On Sun, 2007-12-02 at 10:00 -0600, Afan Pasalic wrote:
> hi barry,
> 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 > ...).
>
>
> -afan
>
>
>
> barry wrote:
> > 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:
> >> Hi,
> >> 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.
> >>
> >> -afan
> >>
> >
> >
>