MySQL :: MySQL 5.7 C API Developer Guide :: 5.4.60 mysql_reset

MySQL 5.7 C API Developer Guide / ... / mysql_reset_connection()

int
mysql_reset_connection(MYSQL *mysql)

Resets the connection to clear the session state.

mysql_reset_connection() has effects similar to mysql_change_user() or an auto-reconnect except that the connection is not closed and reopened, and reauthentication is not done. See Section 5.4.3, “mysql_change_user()”, and Section 3.6.6, “Automatic Reconnection Control”.

mysql_reset_connection() affects the connection-related state as follows:

Rolls back any active transactions and resets autocommit mode.
Releases all table locks.
Closes (and drops) all TEMPORARY tables.
Reinitializes session system variables to the values of the corresponding global system variables, including system variables that are set implicitly by statements such as SET NAMES.
Loses user-defined variable settings.
Releases prepared statements.
Closes HANDLER variables.
Resets the value of LAST_INSERT_ID() to 0.
Releases locks acquired with GET_LOCK().

Zero for success. Nonzero if an error occurred.

PREV HOME UP NEXT