mysql 事物回滚

$handler = mysql_connect('localhost', 'root', 'root')or die("shu ju ku lian jie shibai!");
mysql_select_db('001',$handler)or die("shu ju ku ");
mysql_query('SET AUTOCOMMIT=0'); // 设置为不自动提交查询
mysql_query('START TRANSACTION'); // 开始查询，这里也可以使用BEGIN
$sql1=mysql_query("INSERT INTO `001`.`text` (`name6`)VALUES ('2')");
$sql2=mysql_query("DELETE FROM `text` WHERE username = 'aac'");
if (mysql_affected_rows($handler) == -1) {
mysql_query('ROLLBACK');
echo "回滚";
}else{
mysql_query('COMMIT');
echo "提交";
}
mysql_close($handler);