27.7.6.60 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 27.7.6.3, “mysql_change_user()”, and Section 27.7.19, “C API Automatic Reconnection Control”.
The connection-related state is affected as follows:
Any active transactions are rolled back and autocommit mode is reset.
All table locks are released.
All
TEMPORARY
tables are closed (and dropped).Session system variables are reinitialized to the values of the corresponding global system variables, including system variables that are set implicitly by statements such as
SET NAMES
.User variable settings are lost.
Prepared statements are released.
HANDLER
variables are closed.The value of
LAST_INSERT_ID()
is reset to 0.Locks acquired with
GET_LOCK()
are released.