int mysql_reset_connection(MYSQL * mysql);


Resets the current connection and clears session state. Similar to mysql_change_user() or mariadb_reconnect(), mysql_reset_connection() resets session status, but without disconnecting, opening, or reauthenticating.

On client side mysql_reset_connection()

  • clears pending or unprocessed result sets
  • clears status like affected_rows, info or last_insert_id
  • invalidates active prepared statements

On server side mysql_reset_connection()

  • drops temporary table(s)
  • rollbacks active transaction
  • resets autocommit mode
  • releases table locks
  • initializes session variables (and sets them to the value of corresponding global variables)
  • closes active prepared statements
  • clears user variables

Returns zero on success, non zero if an error occurred.

This function was added in MariaDB Connector/C 3.0.0.


Comments loading...