prepare

Submit an SQL command to the server to be compiled into a prepared statement.

This will automatically register the prepared statement on the provided connection. The resulting mysql.impl.prepared.SafePrepared can then be used freely on ANY mysql.impl.connection.Connection, as it will automatically be registered upon its first use on other connections. Or, pass it to mysql.impl.connection.Connection.register if you prefer eager registration.

Internally, the result of a successful outcome will be a statement handle - an ID - for the prepared statement, a count of the parameters required for execution of the statement, and a count of the columns that will be present in any result set that the command generates.

The server will then proceed to send prepared statement headers, including parameter descriptions, and result set field descriptions, followed by an EOF packet.

@safe
SafePrepared
prepare
(
Connection conn
,
const(char[]) sql
)

Parameters

conn Connection

The connection to use.

sql const(char[])

The SQL statement to prepare.

Throws

mysql.exceptions.MYX if the server has a problem.

Meta