MySQL 8.0 C API Developer Guide
bool mysql_rollback(MYSQL *mysql)
Rolls back the current transaction.
          The action of this function is subject to the value of the
          completion_type system
          variable. In particular, if the value of
          completion_type is
          RELEASE (or 2), the server performs a
          release after terminating a transaction and closes the client
          connection. Call mysql_close()
          from the client program to close the connection from the
          client side.