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]
