1 of 1

COM_STMT_PREPARE

This command prepares an SQL statement on the server, returning a statement ID and metadata about parameters and columns.

Prepares a statement on the server.

Not all statements can be prepared. See PREPARE for a list of statements that can be prepared.

Implemented by

If anything goes wrong, the server will send an . If the command succeeds, different packets are received:

.
If number of parameters (count of '?' placeholders) > 0:
- For each parameter:

0x00 COM_STMT_PREPARE_OK header.
statement ID.
number of columns in the returned result set (or 0 if statement does not return result set).

_{This page is licensed: CC BY-SA / Gnu FDL}

This command prepares an SQL statement on the server, returning a statement ID and metadata about parameters and columns.

Prepares a statement on the server.

Not all statements can be prepared. See PREPARE for a list of statements that can be prepared.

If anything goes wrong, the server will send an . If the command succeeds, different packets are received:

.
If number of parameters (count of '?' placeholders) > 0:
- For each parameter:

0x00 COM_STMT_PREPARE_OK header.
statement ID.
number of columns in the returned result set (or 0 if statement does not return result set).

_{This page is licensed: CC BY-SA / Gnu FDL}

If prepared statement returns result set and number of result set columns > 0: