HEX
Server: LiteSpeed
System: Linux srv1.dhviews.com 5.14.0-570.23.1.el9_6.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Jun 24 11:27:16 EDT 2025 x86_64
User: bdedition (1723)
PHP: 7.4.33
Disabled: NONE
Upload Files
File: //proc/thread-self/root/proc/thread-self/root/usr/share/mysql/man/man3/mysql_commit.3
.\" Automatically generated by Pandoc 2.5
.\"
.TH "mysql_commit" "3" "" "Version 3.3.1" "MariaDB Connector/C"
.hy
.SS Name
.PP
mysql_commit \- Commits the current transaction
.SS Synopsis
.IP
.nf
\f[C]
#include <mysql.h>

my_bool mysql_commit(MYSQL * mysql);
\f[R]
.fi
.SS Description
.PP
Commits the current transaction for the specified database connection.
Returns zero on success, nonzero if an error occurred.
.SS Parameters
.IP \[bu] 2
\f[C]mysql\f[R] is a connection identifier, which was previously
allocated by \f[B]mysql_init(3)\f[R] and connected by
\f[B]mysql_real_connect(3)\f[R].
.SS Notes
.PP
Executing mysql_commit() will not affected the behaviour of autocommit.
This means, any update or insert statements following mysql_commit()
will be rolled back when the connection gets closed.
.PP
== See also * \f[B]mysql_autocommit(3)\f[R] *
\f[B]mysql_rollback(3)\f[R]