5.4.65 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. The write set session history is reset. See Section 5.4.4, “mysql_change_user()”, and Section 3.6.8, “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().

• Clears any current query attributes defined as a result of calling mysql_bind_param().

Return Values

Zero for success. Nonzero if an error occurred.