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. See
Section 7.3, “mysql_change_user()”, and
Chapter 20, 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