mysql\_autocommit(3) MariaDB Connector/C mysql\_autocommit(3)

## [Name](#Name)

mysql\_autocommit - Toggles autocommit mode

## [Synopsis](#Synopsis)

```
#include <mysql.h>
my_bool mysql_autocommit(MYSQL * mysql, my_bool auto_mode);
    
```

## [Description](#Description)

Toggles autocommit mode on or off for the current database connection. Autocommit mode will be set if mode=1 or unset if mode=0.

## [Parameters:](#Parameters:)

•

mysql is a connection identifier, which was previously allocated by [**mysql\_init(3)**](/man/enterprise-packages/mariadb-12.2/mysql_init.3) and connected by [**mysql\_real\_connect(3)**](/man/enterprise-packages/mariadb-12.2/mysql_real_connect.3).

•

auto\_mode - whether to turn autocommit on or not.

## [Notes](#Notes)

•

Autocommit mode only affects operations on transactional table types. To determine the current state of autocommit mode use the SQL command SELECT @@autocommit or check the server status (see example below).

•

Be aware: the [mysql\_rollback()}(mysql\_rollback() function will not work if autocommit mode is switched on.

## [Examples](#Examples)

## [SQL](#SQL)

```
# Turn off autocommit
SET AUTOCOMMIT=0;
# Retrieve autocommit
SELECT @@autocommit;
+--------------+
| @@autocommit |
+--------------+
|            0 |
+--------------+
    
```

## [MariaDB Connector/C](#MariaDB_Connector/C)

```
static int test_autocommit(MYSQL *mysql)
{


  int rc;


  unsigned int server_status;


  


  /* Turn autocommit off */


  rc= mysql_autocommit(mysql, 0);


  if (rc)


    return rc; /* Error */


  /* If autocommit = 0 succeeded, the last OK packet updated the server status */


  rc= mariadb_get_infov(mysql, MARIADB_CONNECTION_SERVER_STATUS, &server_status);


  if (rc)


    return rc; /* Error */


  if (server_status & SERVER_STATUS_AUTOCOMMIT)


  {


    printf("Error: autocommit is on\n");


    return 1;


  }


  printf("OK: autocommit is off\n");


  return 0;
}
    
```

Version 3.4

---

Document: mysql_autocommit(3) from mariadb-12.2 12.2.2-r11 (Chainguard OS)
Source: https://github.com/MariaDB/server.git