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 affec

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