Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
Subject: mysql openssl Question
ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
Update one field with more fields from another table
Subject: Getting Identity after INSERT
ERROR 2002: Can 't connect to local MySQL server through socket
mysql test 4 1 fails with the gis test
Subject: MySQL Cluster Software
Downgrade Mysql from 4 to 3 23
Mysql 4 0 Oracle Stored Procedure Trigger Conversion
Can 't access mysql after kernel upgrade
Executing MySQL Commands From Within C Program
Comparing and writing out BLOBS
Subject: Re: Preventing Duplicate Entries
FULLTEXT query format question
Strange behavior, Table Level Permission
Does the binary log enabling affect the MySQL performances?
mysql:it 's a db not a dbms how it 's possible?!
mysql have same function mthod as Oracle decode()
 
MySQL Browser - limit 1000 by default?

MySQL Browser - limit 1000 by default?

2007-12-02       - By Barry

 Back
Reply:     1     2     3     4  

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
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@(protected)