RE: 1000 row limit in query results window? - Adrian Lew - com.mysql.lists.gui-tools

3 messages in com.mysql.lists.gui-toolsRE: 1000 row limit in query results w...

From	Sent On	Attachments
Steve Forsyth	09 Mar 2004 16:27
Miller, Lachlan S (DTF)	09 Mar 2004 16:30
Adrian Lew	09 Mar 2004 16:45

Subject:	RE: 1000 row limit in query results window?
From:	Adrian Lew (adri...@easytel.net)
Date:	03/09/2004 04:45:51 PM
List:	com.mysql.lists.gui-tools

Or you can use the LIMIIT keyword At the end of the query to indicate The max number of returned records.

For Example, This query would limit the max # of records To 50,000:

SELECT * FROM mailbox WHERE box = '123456789' LIMIT 1, 50000;

This is what I sometimes do.

-----Original Message----- From: Miller, Lachlan S (DTF) [mailto:Mill...@saugov.sa.gov.au] Sent: Tuesday, March 09, 2004 4:31 PM To: 'Steve Forsyth'; mysq...@lists.mysql.com Subject: RE: 1000 row limit in query results window?

right click on the server (top most object on the tree) and select edit

from there go to the mysql options tab, you will see the query limit field

many ppl ask this, it took me ages to find it too

have fun

-----Original Message----- From: Steve Forsyth [mailto:stev...@hotmail.com] Sent: Wednesday, 10 March 2004 10:58 AM To: mysq...@lists.mysql.com Subject: 1000 row limit in query results window?

I'm hoping that I'm blind... but I can't seem to find any options to set the

query window results to allow more than 1000 rows. I also couldn't find anything on mysql.com

Sorry if this is total idiot question... cause I sure feel like it is :)