On Thu, 20 Jun 2002, Flavio Reis wrote:
> Hi Galen! > The problem is that command act on client, I need a command to act on server > (mysqld)! > Thanks > []s > Flavio > select_limit is a client variable, not a server variable. A second look at the documentation suggests adding the line "set-variable = select_limit=$LIMIT" to the [client] section will do the trick, but this option only has an affect if --safe-updates is specified on the command line or safe-updates is put in the [client] section. See manual section 4.1.2 for more on my.cnf and section 4.8.2 for more on the --safe-updates option. > -----Mensagem original----- > De: Galen Wright-Watson [mailto:[EMAIL PROTECTED]] > Enviada em: quinta-feira, 20 de junho de 2002 18:18 > Para: Flavio Reis > Cc: [EMAIL PROTECTED] > Assunto: Re: Problems with SQL_SELECT_LIMIT > > > On Thu, 20 Jun 2002, Flavio Reis wrote: > > > Hi. > > I have an urgent question: > > How can I set the variable sql_select_limit as a global variable, which > > everytime that I open the MySQL it's set to the value that I determinated. > I > > want to know how set this variable in the mysql.conf (where and how), not > > inside the BD! > > Thank you!!! > > Flávio > > > > After going through the documentation (and messing with the server > configuration file), it appears there is no method of setting > sql_select_limit > (or select_limit) from the server config file. However, if you're running > MySQL > on a Unix system, you could 'alias mysql "mysql -O select_limit=$LIMIT"' in > the > global login scripts, or 'mv mysql mysql.orig' and create a shell script > called > 'mysql' with the line 'mysql -O select_limit=$LIMIT"' (replace $LIMIT with > whatever value you want). --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php