mysql_commit

mysql_commit commits the current transaction on a MariaDB Connector/C connection, returning zero on success without affecting autocommit mode.

Syntax

my_bool mysql_commit(MYSQL * mysql);

Parameter

• mysql - a mysql handle, which was previously allocated by mysql_init() or mysql_real_connect().

Description

Commits the current transaction for the specified database connection.

Return Value

Returns zero on success, nonzero if an error occurred.

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.

See Also

• mysql_rollback()

• mysql_autocommit()

_{This page is: Copyright © 2026 MariaDB. All rights reserved.}