mysql_stmt_reset — Resets a prepared statement.

my_bool mysql_stmt_reset(MYSQL_STMT * stmt);

Resets a prepared statement on client and server to state after prepare.

Parameters

stmt

A statement handle, which was previously allocated by mysql_stmt_init().

Return value

Zero on success, nonzero if an error occured.

[Note]

mysql_stmt_reset() resets the statement on the server, unbuffered result sets and errors. Bindings and stored result sets will not be cleared. The latter one will be cleared when reexecuting or closing the prepared statement.

To reprepare a prepared statement with another SQL statement use mysql_stmt_prepare().

See also

mysql_stmt_close(), mysql_stmt_prepare(), mysql_stmt_execute()