2 messages in com.mysql.lists.mysqlRe: Force a COMMIT on InnoDB tables?
FromSent OnAttachments
patrick28 Mar 2006 16:47 
Wolfram Kraus28 Mar 2006 22:23 
Subject:Re: Force a COMMIT on InnoDB tables?
From:Wolfram Kraus (kra@hagen-partner.de)
Date:03/28/2006 10:23:19 PM
List:com.mysql.lists.mysql

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