COM_STMT_PREPARE

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

• mariadb_stmt_execute_direct()
• mysql_stmt_prepare()

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

COM_STMT_PREPARE response

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

• COM_STMT_PREPARE_OK
• if number of parameters (count of '?' placeholders) > 0
  • for each parameter:
    • column definition packet
  • if !DEPRECATE_EOF eof_packet
• if prepared statement returns result set and number of result set columns > 0
  • for each column:
    • column definition packet
  • if !DEPRECATE_EOF eof_packet

COM_STMT_PREPARE_OK