Question

php mysql 事务无法回滚 rollback不起作用

<?php
header ( "Content-type: text/html;charset=utf-8" );
$mysqli = new MySQLi ( "localhost", "root", "123456", "test" );
if ($mysqli->connect_error) {
die ( "error!!".$mysqli->connect_error );
}
$mysqli->autocommit ( false );
$sql_1 = "update account set balance=balance-2 where id=1";
$sql_2 = "update accountx set balance=balance+2 where id=2";
$Q1 = $mysqli->query ( $sql_1 );
$Q2 = $mysqli->query ( $sql_2 );
if (!$Q2 || !$Q1) {
echo $mysqli->error;
$mysqli->rollback ();
} else {
$mysqli->commit ();
}
$mysqli->close ();
?>

Answer 1

MYSQL中只有INNODB和BDB类型的数据表才能支持事务处理,其他的类型是不支持的.
你可以检查下你的数据库用的什么引擎

Answer 2

c30和v3菱悦2013那辆