In Windows MySQLCC open a query window; select query menu; query window options; query options tab; set SQL_BIG_SELECTS=1.
http://www.mysql.com/doc/en/SET_OPTION.html Quote: SQL_BIG_SELECTS = 0 | 1 If set to 0, MySQL will abort if a SELECT is attempted that probably will take a very long time. This is useful when an inadvisable WHERE statement has been issued. A big query is defined as a SELECT that probably will have to examine more than MAX_JOIN_SIZE rows. The default value for a new connection is 1 (which will allow all SELECT statements). ----- Original Message ----- From: "Nils Valentin" <[EMAIL PROTECTED]> To: "Cabanillas Dulanto Ulises" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, August 09, 2003 9:21 AM Subject: Re: MySql Control Center Hi Ulises, Is that option only available on a Windows MySQLCC ?? I didnt find it on the linux version. Best regards Nils Valentin Tokyo/Japan 2003年 8月 9日 土曜日 01:47、Cabanillas Dulanto, Ulises さんは書きました: > The option "Automatically limit SELECT queries to nnnn" must be set in the > Query Configuration Dialog. > > Regards, > Ulises > > -----Mensaje original----- > De: Trevor Morrison [mailto:[EMAIL PROTECTED] > Enviado el: Viernes 8 de Agosto de 2003 09:36 AM > Para: [EMAIL PROTECTED] > Asunto: MySql Control Center > > > Hi, > > I am new to using the Control Center-0.9.2-beta. My problem is that I > cannot seem to display more than 1000 rows in my result set when I know > that there is 1534 rows. I know that it is a setting somewhere, but is it > in MySql or in the Control Center somewhere. I am running this on a > Windows 2000 machine. > > TIA > > Trevor -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.506 / Virus Database: 303 - Release Date: 01/08/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
