FreeBSD Manual Pages
mysql_reset_connection(3) MariaDB Connector/C mysql_reset_connection(3)
Name
mysql_reset_connection - Resets connection and clears session state
Synopsis
#include <mysql.h>
int mysql_reset_connection(MYSQL * mysql);
Description
Resets the current connection and clears session state. Similar to
mysql_change_user(3) or mariadb_reconnect(3), mysql_reset_connection() re-
sets session status, but without disconnecting, opening, or reauthenticat-
ing.
On client side mysql_reset_connection() * clears pending or unprocessed re-
sult sets * clears status like affected_rows, info or last_insert_id * in-
validates active prepared statements
On server side mysql_reset_connection() * drops temporary table(s) * roll-
backs 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 vari-
ables
Parameter
* mysql - a mysql handle, which was previously allocated by mysql_init(3)
and connected by mysql_real_connect(3).
Return value
Returns zero on success, non zero if an error occurred.
History
This function was added in MariaDB Connector/C 3.0.0.
See also
* mariadb_cancel(3)
* mysql_kill(3)
Version 3.4 mysql_reset_connection(3)
Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=mysql_reset_connection&sektion=3&manpath=FreeBSD+Ports+15.1.quarterly>