Man page - mysql_autocommit(3)
Packages contains this manual
- mysql_stmt_bind_result(3)
- mariadb_connection(3)
- mysql_sqlstate(3)
- mysql_stmt_fetch(3)
- mysql_options(3)
- mysql_stmt_errno(3)
- mysql_data_seek(3)
- mysql_stmt_store_result(3)
- mariadb_rpl_optionsv(3)
- mysql_info(3)
- mariadb_rpl_get_optionsv(3)
- mysql_warning_count(3)
- mysql_store_result(3)
- mysql_ssl_set(3)
- mysql_stmt_warning_count(3)
- mysql_stmt_free_result(3)
- mysql_server_init(3)
- mysql_stmt_insert_id(3)
- mariadb_dyncol_update_many_named(3)
- mariadb_dyncol_exists_named(3)
- mysql_get_character_set_info(3)
- mysql_errno(3)
- mysql_hex_string(3)
- mysql_init(3)
- mariadb_dyncol_list_num(3)
- mysql_free_result(3)
- mysql_stmt_field_count(3)
- mysql_reset_connection(3)
- mariadb-config(1)
- mysql_session_track_get_first(3)
- mysql_thread_end(3)
- mysql_refresh(3)
- mariadb_dyncol_column_cmp_named(3)
- mysql_set_character_set(3)
- mysql_real_escape_string(3)
- mysql_kill(3)
- mysql_server_end(3)
- mariadb_get_infov(3)
- mysql_stmt_error(3)
- mysql_thread_init(3)
- mysql_stmt_prepare(3)
- mysql_stmt_send_long_data(3)
- mysql_get_ssl_cipher(3)
- mariadb_dyncol_update_many_num(3)
- mariadb_dyncol_check(3)
- mariadb_dyncol_list_named(3)
- mysql_real_query(3)
- mysql_stmt_attr_get(3)
- mysql_select_db(3)
- mariadb_dyncol_create_many_num(3)
- mysql_get_client_info(3)
- mysql_config(1)
- mysql_close(3)
- mariadb_rpl_close(3)
- mariadb_dyncol_create_many_named(3)
- mysql_rollback(3)
- mysql_fetch_lengths(3)
- mysql_stmt_row_seek(3)
- mariadb_dyncol_free(3)
- mysql_commit(3)
- mysql_autocommit(3)
- mariadb_dyncol_column_count(3)
- mysql_stmt_close(3)
- mysql_num_fields(3)
- mariadb_rpl_open(3)
- mysql_num_rows(3)
- mysql_stmt_more_results(3)
- mysql_optionsv(3)
- mysql_field_tell(3)
- mysql_get_proto_info(3)
- mysql_stmt_row_tell(3)
- mysql_query(3)
- mysql_change_user(3)
- mariadb_reconnect(3)
- mysql_row_tell(3)
- mysql_stmt_reset(3)
- mysql_set_server_option(3)
- mysql_fetch_fields(3)
- mysql_get_socket(3)
- mysql_more_results(3)
- mysql_field_seek(3)
- mysql_stmt_bind_param(3)
- mysql_read_query_result(3)
- mysql_stmt_data_seek(3)
- mysql_fetch_field(3)
- mysql_field_count(3)
- mysql_stmt_param_count(3)
- mysql_get_server_info(3)
- mysql_get_client_version(3)
- mysql_stmt_init(3)
- mysql_stmt_fetch_column(3)
- mysql_use_result(3)
- mysql_ping(3)
- mysql_real_connect(3)
- mysql_stmt_attr_set(3)
- mysql_stmt_sqlstate(3)
- mysql_error(3)
- mysql_stmt_affected_rows(3)
- mysql_send_query(3)
- mysql_stmt_param_metadata(3)
- mysql_stat(3)
- mariadb_cancel(3)
- mysql_thread_id(3)
- mysql_stmt_num_rows(3)
- mysql_affected_rows(3)
- mysql_next_result(3)
- mariadb_config(1)
- mysql_get_host_info(3)
- mariadb_dyncol_unpack(3)
- mysql_fetch_row(3)
- mysql_get_server_version(3)
- mysql_stmt_result_metadata(3)
- mysql_stmt_execute(3)
- mysql_stmt_next_result(3)
- mysql_fetch_field_direct(3)
- mysql_options4(3)
- mysql_session_track_get_next(3)
- mariadb_dyncol_exists_num(3)
- mysql_row_seek(3)
- mariadb_stmt_fetch_fields(3)
- mariadb_stmt_execute_direct(3)
- mysql_shutdown(3)
- mariadb_rpl_fetch(3)
apt-get install libmariadb-dev
Manual
mysql_autocommit
NameSynopsis
Description
Parameters:
Notes
Examples
SQL
MariaDB Connector/C
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
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;
}