X
  • Search
  • Products
  • Services
  • Resources
  • About
  • Contact
  • Login

Copyright © 2021 MariaDB. All rights reserved.

  • Knowledge Base
  • Contact
  • Login
  • Search
  • Products
  • Services
  • Pricing
  • Resources
  • About Us
  • Download
Knowledge Base » Server & Client Software » Client Libraries » Client/Server Protocol » 3 - Binary Protocol (Prepared Statements)
  • Home
  • Open Questions
  • MariaDB Server
  • MariaDB MaxScale
  • MariaDB ColumnStore
  • Connectors
Ask a question here
Product Versions

3 - Binary Protocol (Prepared Statements)

The binary protocol defines a non-text-based (binary) format that is used instead of the text protocol, only for prepared statements.

  • Server Response Packets (Binary Protocol)

    Response packets sent from the server to client in binary protocol
  • COM_STMT_BULK_EXECUTE

    Executes a bulk insert of a previously prepared statement.
  • COM_STMT_CLOSE

    Closes a previously prepared statement
  • 9

    COM_STMT_EXECUTE

    Executes a previously prepared statement
  • COM_STMT_FETCH

    Fetches rows from a prepared statement
  • COM_STMT_PREPARE

    Prepares a statement on the server
  • COM_STMT_RESET

    Resets a prepared statement on client and server to state after preparing
  • COM_STMT_SEND_LONG_DATA

    When data for a specific column is big, it can be sent separately
  • ← 2 - Text Protocol
  • ↑ Client/Server Protocol ↑
  • 4 - Server Response Packets →
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.
  • ↑ Client/Server Protocol ↑
  • 0 - Packet
  • 1 - Connecting
  • 2 - Text Protocol
  • 3 - Binary Protocol (Prepared Statements)
  • 4 - Server Response Packets
  • Protocol data types
  • Replication Protocol
Products
  • MariaDB Platform
  • MariaDB Platform Managed Service
  • ClustrixDB
  • Pricing
  • Downloads
Services
  • Enterprise Architect
  • Migration Practice
  • Remote DBA
  • Consulting
  • Technical Support Services
  • Training
Resources
  • Blog
  • Events
  • OpenWorks 2019
  • Roadshow
  • Support
About MariaDB
  • Leadership
  • Partners
  • Contact
  • Newsroom
  • Investors
  • Careers
Contact

Subscribe to our newsletter!

  • Legal
  • Privacy Policy
  • Cookies

Copyright © 2021 MariaDB. All rights reserved.