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]

Reply via email to