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);

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

Description

Rolls back the current transaction for the database. 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()