mysql_autocommit
You are viewing an old version of this article. View
the current version here.
Syntax
my_bool mysql_autocommit(MYSQL * mysql, my_bool auto_mode);
mysql- a mysql handle, identifier, which was previously allocated by mysql_init() or mysql_real_connect().auto_mode- whether to turn autocommit on or not.
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. Returns zero on success, or nonzero if an error occurred. Parameters
Autocommit mode only affects operations on transactional table types. To determine the current state of autocommit mode use the SQL command SELECT @@autocommit. Be aware: the mysql_rollback() function will not work if autocommit mode is switched on.
Turning off autocommit in sql
SET AUTOCOMMIT=0;
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
