14.7 Prepared Statements

14.7.1 Binary Protocol Resultset

14.7.2 Binary Protocol Resultset Row

14.7.3 Binary Protocol Value

14.7.4 COM_STMT_PREPARE

14.7.5 COM_STMT_SEND_LONG_DATA

14.7.6 COM_STMT_EXECUTE

14.7.7 COM_STMT_CLOSE

14.7.8 COM_STMT_RESET

The prepared statement protocol was introduced in MySQL 4.1 and adds a few new commands:

• COM_STMT_PREPARE

• COM_STMT_EXECUTE

• COM_STMT_CLOSE

• COM_STMT_RESET

• COM_STMT_SEND_LONG_DATA

It also defines a more compact resultset format that is used instead of the ProtocolText::Resultset to return resultsets.

Keep in mind that not all statements can be prepared:

WL2871