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
