mysql交易,MySQL的交易 - 无法回滚

I'm using MySQL 5.0.27 and am trying to get transactions to work. I followed this tutorial:

and still cannot get these to work. The table I am trying to update is InnoDB and have tried to execute 'set autocommit=0' but it doesn't seem to be doing anything.... The code I've written is the following:

public int transactionUpdate()

{

MySqlConnection connection = new MySqlConnection(connStr);

connection.Open();

MySqlCommand command = connection.CreateCommand();

MySqlTransaction trans;

trans = connection.BeginTransaction();

command.Connection = connection;

command.Transaction = trans;

try

{

command.CommandText = "SET autocommit = 0";

command.executeNonQuery();

command.CommandText = "UPDATE TBL.rec_lang rl SET rl.lang_code = 'en-us' WHERE rl.recording=123456";

command.executeNonQuery();

command.CommandText = "UPDATE TBL.rec_lang rl SET rl.lang_code = en-us WHERE rl.recording=123456";

command.executeNonQuery();

trans.Commit();

}

catch(Exception ex)

{

try

{

trans.Rollback();

}

catch(MySqlException mse)

{

log.error(mse);

}

}

}

The second command fails as it is missing the ' around 'en-us'. This should roll back the first query as well to a previous value but it isn't. Can you tell me what I'm doing wrong???

MySQLConnector v. 6.3.6.0

MySQL v. 5.0.27

C# VS2010

解决方案

I had a second database open that had bad data showing ><... this method works : turns out i didn even need:>

command.CommandText = "SET autocommit = 0";

command.executeNonQuery();

So the good news is this code does work for transactions... bad news i didn't figure it out until i posted ;)