mysql_rollback

mysql_rollback undoes the current transaction for a database connection; it has no effect if autocommit is enabled or the engine is non-transactional.

Syntax

my_bool mysql_rollback(MYSQL * mysql);

Parameter

• mysql - a mysql handle, which was previously allocated by mysql_init() or mysql_real_connect().

Description

Rolls back the current transaction for the database.

Return Value

Returns zero on success, nonzero if an error occurred.

mysql_rollback() will not work as expected if autocommit mode was set or the storage engine does not support transactions.

See Also

• mysql_commit()

• mysql_autocommit()

_{This page is: Copyright © 2026 MariaDB. All rights reserved.}