Ok, thanks. - Christian Caron
> -----Original Message----- > From: Greg Fortune [mailto:[EMAIL PROTECTED] > Sent: 7 mars, 2005 13:58 > To: mysql@lists.mysql.com > Cc: Caron, Christian > Subject: Re: what is select_limit (and what is it used for)? > > > It only affects the client and only when the --safe-updates, > --i-am-a-dummy, > -U flag is used. I assume it just places an explicit limit > clause of LIMIT > 1000 on the end of any select statement run from the client. > It's meant to > keep less experienced users from running a couple of cross > product joins that > output millions of lines of data. > > Greg Fortune > > On Monday 07 March 2005 10:48 am, Caron, Christian wrote: > > Hi, > > > > the default "select_limit" is set to 1000. What does this > mean and how can > > it affect a server? > > > > Is there some information out there about this variable? I > can't find > > anything except a one line description on the MySQL site... > > > > - > > Christian Caron > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]