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) and connected by mysql_real_connect(3).

•   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 of autocmmit
    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;
    }