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

• int<1> 0x16 COM_STMT_PREPARE header

• string SQL Statement

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

• 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}