Setting Dynamic Variables

2004-04-20 Thread Lou Olsten 
I've found two methods that both seem to work fine (on 4.0.18) for setting dynamic 
variables:

mysql set @@session.autocommit=0;
mysql set session autocommit=0;

Which is the preferred (latest) method?  Is one eventually going to be deprecated?

Thanks,

Lou

Re: Setting Dynamic Variables

2004-04-20 Thread Paul DuBois 
At 12:33 -0400 4/20/04, Lou Olsten wrote:
I've found two methods that both seem to work fine (on 4.0.18) for 
setting dynamic variables:

mysql set @@session.autocommit=0;
mysql set session autocommit=0;
Which is the preferred (latest) method?  Is one eventually going to 
be deprecated?
1) They're the same.
2) Neither is the latest; they were both added in 4.0.3.
3) No.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]