MySQL 5.7 C API Developer Guide
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().