int mysql_reset_connection(MYSQL *mysql)
Resets the connection to clear the session state.
effects similar to
mysql_change_user() or an
auto-reconnect except that the connection is not closed and
reopened, and reauthentication is not done. The write set
session history is reset. See
Section 7.4, “mysql_change_user()”, and
Chapter 28, C API Automatic Reconnection Control.
affects the connection-related state as follows:
Rolls back any active transactions and resets autocommit mode.
Releases all table locks.
Closes (and drops) all
Reinitializes session system variables to the values of the corresponding global system variables, including system variables that are set implicitly by statements such as
Loses user-defined variable settings.
Releases prepared statements.
Resets the value of
Releases locks acquired with
Clears any current query attributes defined as a result of calling