Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
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()
       resets session status, but without disconnecting, opening, or reauthen-
       ticating.

       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

   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+14.3.quarterly>

home | help