MySQL :: MySQL 8.4 C API Developer Guide :: 6.4.23 mysql_stmt_reset() (original) (raw)

The world's most popular open source database

6.4.23 mysql_stmt_reset()

bool
mysql_stmt_reset(MYSQL_STMT *stmt)

Description

Resets a prepared statement on client and server to state after prepare. It resets the statement on the server, data sent usingmysql_stmt_send_long_data(), unbuffered result sets and current errors. It does not clear bindings or stored result sets. Stored result sets will be cleared when executing the prepared statement (or closing it).

To re-prepare the statement with another query, usemysql_stmt_prepare().

Return Values

Zero for success. Nonzero if an error occurred.

Errors

• CR_COMMANDS_OUT_OF_SYNC
  Commands were executed in an improper order.
• CR_SERVER_GONE_ERROR
  The MySQL server has gone away.
• CR_SERVER_LOST
  The connection to the server was lost during the query
• CR_UNKNOWN_ERROR
  An unknown error occurred.