what is select_limit (and what is it used for)?

2005-03-07 Thread Caron, Christian
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:

Re: what is select_limit (and what is it used for)?

2005-03-07 Thread Greg Fortune
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

RE: what is select_limit (and what is it used for)?

2005-03-07 Thread Caron, Christian
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