int mysql_reset_connection(MYSQL *mysql)
Resets the connection to clear the session state. This function was added in MySQL 5.7.3.
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 22.214.171.124, “mysql_change_user()”) and see
Section 22.8.16, “Controlling Automatic Reconnection Behavior”).
The connection-related state is affected as follows:
Any active transactions are rolled back and autocommit mode is reset.
All table locks are released.
TEMPORARY tables are closed (and
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
User variable settings are lost.
Prepared statements are released.
HANDLER variables are closed.
The value of
is reset to 0.
Locks acquired with
GET_LOCK() are released.
Zero for success. Nonzero if an error occurred.