mysql事务回滚代码怎么写

START TRANSACTION;

-- 执行一系列的SQL语句
INSERT INTO table_name (column1, column2) VALUES ('value1', 'value2');
UPDATE table_name SET column1 = 'new_value' WHERE condition;
DELETE FROM table_name WHERE condition;

-- 如果在执行过程中出现错误，则进行回滚
-- 注意：这里的ROLLBACK是在判断条件后手动执行的，实际应用中可以根据异常捕获来自动执行
IF error_occurred THEN
    ROLLBACK;
ELSE
    COMMIT; -- 如果没有错误，提交事务
END IF;

<?php
$mysqli = new mysqli("localhost", "user", "password", "database");

if ($mysqli->connect_error) {
    die("连接失败: " . $mysqli->connect_error);
}

$mysqli->begin_transaction();

try {
    $sql1 = "INSERT INTO table_name (column1, column2) VALUES ('value1', 'value2')";
    if (!$mysqli->query($sql1)) throw new Exception($mysqli->error);

    $sql2 = "UPDATE table_name SET column1 = 'new_value' WHERE condition";
    if (!$mysqli->query($sql2)) throw new Exception($mysqli->error);

    $sql3 = "DELETE FROM table_name WHERE condition";
    if (!$mysqli->query($sql3)) throw new Exception($mysqli->error);

    $mysqli->commit();
    echo "事务提交成功";
} catch (Exception $e) {
    $mysqli->rollback();
    echo "事务回滚: " . $e->getMessage();
}
?>