mirror of
https://github.com/VCMP-SqMod/SqMod.git
synced 2024-11-08 08:47:17 +01:00
49 lines
1.4 KiB
Groff
49 lines
1.4 KiB
Groff
|
.\" Automatically generated by Pandoc 2.5
|
||
|
|
.\"
|
||
|
|
.TH "mysql_reset_connection" "3" "" "Version 3.2.2" "MariaDB Connector/C"
|
||
|
|
.hy
|
||
|
|
.SS Name
|
||
|
|
.PP
|
||
|
|
mysql_reset_connection \- Resets connection and clears session state
|
||
|
|
.SS Synopsis
|
||
|
|
.IP
|
||
|
|
.nf
|
||
|
|
\f[C]
|
||
|
|
#include <mysql.h>
|
||
|
|
|
||
|
|
int mysql_reset_connection(MYSQL * mysql);
|
||
|
|
\f[R]
|
||
|
|
.fi
|
||
|
|
.SS Description
|
||
|
|
.PP
|
||
|
|
Resets the current connection and clears session state.
|
||
|
|
Similar to \f[B]mysql_change_user(3)\f[R] or
|
||
|
|
\f[B]mariadb_reconnect(3)\f[R], mysql_reset_connection() resets session
|
||
|
|
status, but without disconnecting, opening, or reauthenticating.
|
||
|
|
.PP
|
||
|
|
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
|
||
|
|
.PP
|
||
|
|
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
|
||
|
|
.SS Parameter
|
||
|
|
.IP \[bu] 2
|
||
|
|
\f[C]mysql\f[R] \- a mysql handle, which was previously allocated by
|
||
|
|
\f[B]mysql_init(3)\f[R] and connected by
|
||
|
|
\f[B]mysql_real_connect(3)\f[R].
|
||
|
|
.SS Return value
|
||
|
|
.PP
|
||
|
|
Returns zero on success, non zero if an error occurred.
|
||
|
|
.SS History
|
||
|
|
.PP
|
||
|
|
This function was added in MariaDB Connector/C 3.0.0.
|
||
|
|
.SS See also
|
||
|
|
.IP \[bu] 2
|
||
|
|
\f[B]mariadb_cancel(3)\f[R]
|
||
|
|
.IP \[bu] 2
|
||
|
|
\f[B]mysql_kill(3)\f[R]
|