COM_STMT_EXECUTE

You are viewing an old version of this article. View the current version here.

Executes a previously prepared statement.

If specific data is large, it can be send separately prior to this command (see COM_STMT_SEND_LONG_DATA).

Direction

Client to server.

Fields

  • int<1> 0x17 : COM_STMT_EXECUTE header
  • int<4> statement id
  • int<1> flags:
  • int<4> Iteration count
  • if (param_count > 0)
    • if (Iteration count == 1)
    • byte<1> new-params-bound-flag(0 / 1)
    • if (new-params-bound-flag)
    • for each iteration (i.e interation_count times)
      • for each parameter (i.e param_count times)
        • if (indicator_variable_used && extended_capabilities & MARIADB_CLIENT_STMT_BULK_OPERATIONS >> 32)
          • int<1> indicator_variable (0 = null value, 1 =default value)
        • byte<n> binary parameter value

Flag

0no cursor
1read only
2cursor for update
4scrollable cursor
128return all insert ids

Parameter flag

parameter type flag byte:

64indicator variable used
(if extended_capabilities & MARIADB_CLIENT_STMT_BULK_OPERATIONS >> 32)
128unsigned

NULL-Bitmap

The NULL-Bitmap indicates if parameters are null (one bit per parameter).
NULL-bitmap size is (parameter number + 7) / 8

COM_STMT_EXECUTE response

The server can answer with 3 different responses:

  • 0xff: ERR_Packet if any errors occur.
  • 0x00: OK_packet when query execution works without resultset.
  • one (or more) Resultset, when query execution return rows (in case of SELECT query for example).

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.