Module Mysql.Prepared

module Prepared: sig .. end
Prepared statements with parameters. Consult the MySQL manual for detailed description and possible problems.

type stmt 
Prepared statement
type stmt_result 
Prepared query result (rowset)
val create : Mysql.dbd -> string -> stmt
Create prepared statement. Placeholders for parameters are ? and @param. Returned prepared statement is only valid in the context of this connection and can be reused many times during the lifetime of the connection.
val execute : stmt -> string array -> stmt_result
Execute the prepared statement with the specified values for parameters.
val execute_null : stmt -> string option array -> stmt_result
Same as Mysql.Prepared.execute, but with support for NULL values.
val affected : stmt -> int64
Returns Number of rows affected by the last execution of this statement.
val insert_id : stmt -> int64
Returns The rowid of the last inserted row.
val real_status : stmt -> int
Returns the error code for the last operation on this statement, 0 for success.
val fetch : stmt_result -> string option array option
Returns the next row of the result set.
val result_metadata : stmt -> Mysql.result
Returns metadata on the statement's result set.
val close : stmt -> unit
Destroy the prepared statement