---
name: "mysql_autocommit"
section: "3"
platform: "linux"
package: "mariadb"
version: "13.0.2-2"
release: "Arch Linux 2026-11-01"
platforms: ["linux"]
url: "https://new.carta.tech/mysql_autocommit"
---

# mysql\_autocommit(3)

### Name

mysql\_autocommit - Toggles autocommit mode

### Synopsis

-

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

### 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:

- •

  `mysql` is a connection identifier, which was previously allocated by **[mysql\_init(3)](/mysql_init/3.md)** and connected by **[mysql\_real\_connect(3)](/mysql_real_connect/3.md)**.

- •

  `auto_mode` - whether to turn autocommit on or not.

### 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

### SQL

-

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

### 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;
  }
  ```