Mysql指定表不回滚_mysql创建的innodb表为什么回滚不了

我在创建mysql表时语句有加ENGINE=InnoDB，然后下面是我的事务

百度说只有存储引擎为ENGINE=InnoDB才可以用事务

public static bool NonQuery(string connStr, string firstSql, string secondSql, out string strErrorInfo)

{

strErrorInfo = "";

bool flag = false;

using (MySqlConnection conn = new MySqlConnection(connStr))

{

if (conn.State != ConnectionState.Open)

conn.Open();

MySqlTransaction transaction = conn.BeginTransaction();

MySqlCommand comm = new MySqlCommand();

comm.Connection = conn;

comm.Transaction = transaction;

try

{

comm.CommandText = firstSql;

if (comm.ExecuteNonQuery() > 0)

{

comm.CommandText = secondSql;

if (comm.ExecuteNonQuery() > 0)

{

flag = true;

}

else

{

flag = false;

}

}

else

{

flag = false;

}

transaction.Commit();

}

catch (Exception ex)

{

strErrorInfo = ex.Message + ex.StackTrace;

transaction.Rollback();

// string sql = "DROP TABLE if EXISTS `tmp_Card`;";

// comm.CommandText = sql;

//comm.ExecuteNonQuery();

}

//finally

//{

// comm.Dispose();

// conn.Close();

//}

return flag;

}

}

http://blog.csdn.net/ying_593254979/article/details/12095169

看了好多说要修改@@autocommit这个；因为默认的为自动提交为1；

但是我应用程序中已经明确了 conn.BeginTransaction();还需要设置这个@@autocommit？