Documentation Home
MySQL 5.7 C API Developer Guide
Download this Manual
PDF (US Ltr) - 1.1Mb
PDF (A4) - 1.1Mb
HTML Download (TGZ) - 141.5Kb
HTML Download (Zip) - 164.5Kb


MySQL 5.7 C API Developer Guide  /  C API Function Descriptions  /  mysql_reset_connection()

7.60 mysql_reset_connection()

int mysql_reset_connection(MYSQL *mysql)

Description

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

Return Values

Zero for success. Nonzero if an error occurred.