mysql - a MySQL handle, which was previously allocated by mysql_init() or mysql_real_connect().
Resets the current connection and clears session state. Similar to or , 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 auto commit mode
releases table locks
Returns zero on success, non-zero if an error occurred.
This function was added in MariaDB Connector/C 3.0.0.
int mysql_reset_connection(MYSQL * mysql);closes active prepared statements
clears user variables