This is a read-only copy of the MariaDB Knowledgebase generated on 2024-12-22. For the latest, interactive version please visit https://mariadb.com/kb/.

mysql_stmt_reset

Syntax

my_bool mysql_stmt_reset(MYSQL_STMT * stmt);
  • stmt - a statement handle, which was previously allocated by mysql_stmt_init(). Returns zero on success, nonzero if an error occurred.

Description

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

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 re-executing or closing the prepared statement.

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

See Also

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.