# mysql\_rollback

## Syntax

```c
my_bool mysql_rollback(MYSQL * mysql);
```

* `mysql` - a mysql handle, which was previously allocated by [mysql\_init()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_init) or [mysql\_real\_connect()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_real_connect).

## Description

Rolls back the current transaction for the database. Returns zero on success, nonzero if an error occurred.

{% hint style="info" %}
`mysql_rollback()` will not work as expected if [autocommit](https://app.gitbook.com/s/SsmexDFPv2xG2OTyO5yV/server-management/variables-and-modes/server-system-variables#autocommit) mode was set or the storage engine does not support transactions.
{% endhint %}

## See also

* [mysql\_commit()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_commit)
* [mysql\_autocommit()](https://mariadb.com/docs/connectors/mariadb-connector-c/api-functions/mysql_autocommit)

{% @marketo/form formId="4316" %}