COM_STMT_PREPARE
Prepares a statement on the server.
Implemented by
Fields
Example
1F 00 00 00 16 53 45 4C 45 43 54 20 2A 20 46 52 .....SELECT * FR
1F 4D 20 74 65 73 74 5F 62 69 6E 64 5F 72 65 73 OM test_bind_res
75 6C 74 ult
Response
If anything goes wrong, the server will send an ERR_Packet. If the command succeeds, different packets are received:
If number of parameters (count of '?' placeholders) >
0
:For each parameter:
If !
DEPRECATE_EOF
eof_packet.
If prepared statement returns result set and number of result set columns >
0
:For each column:
If !
DEPRECATE_EOF
eof_packet.
COM_STMT_PREPARE_OK
int<1>
0x00
COM_STMT_PREPARE_OK
header.int<4> statement ID.
int<2> number of columns in the returned result set (or 0 if statement does not return result set).
int<2> number of prepared statement parameters ('?' placeholders).
string<1> -not used-
int<2> number of warnings.
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?