Prepared Statements

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

• COM_STMT_PREPARE
• COM_STMT_EXECUTE
• COM_STMT_FETCH
• COM_STMT_CLOSE
• COM_STMT_RESET
• COM_STMT_SEND_LONG_DATA

It also defines a more compact resultset format that is used instead of Text Resultset to return the results.

Note

Keep in mind that not all SQL statements can be prepared.

See also

WL#2871