Re: Force a COMMIT on InnoDB tables? - Wolfram Kraus - com.mysql.lists.mysql

2 messages in com.mysql.lists.mysqlRe: Force a COMMIT on InnoDB tables?

From	Sent On	Attachments
patrick	28 Mar 2006 16:47
Wolfram Kraus	28 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