my_bool mysql_rollback(MYSQL * mysql);
mysql - a mysql handle, which was previously allocated by mysql_init() or mysql_real_connect().
mysql
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 mode was set or the storage engine does not support transactions.
mysql_commit()
mysql_autocommit()