Is there any way to make this the default behaviour? I did a Google search, and it was suggested I put the following line in /etc/my.cnf:
[mysqld] init_connect='set autocommit=0' This works fine, but I worry that this will affect all incoming connections regardless of whether or not they are from the command-line client. Is there a way to set this just for the client, like some option that would go in the [mysql] section? Patrick On 3/28/06, Wolfram Kraus <[EMAIL PROTECTED]> wrote: > patrick wrote: > > I'm wondering if there's any way to force updates on InnoDB tables to > > require an explicit COMMIT when running queries from the mysql > > command-line client (similar to Oracle's command line client)? > > > > set autocommit = 0 > See > http://dev.mysql.com/doc/refman/5.0/en/innodb-and-autocommit.html > > HTH, > Wolfram > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
