Boost C++ Libraries

...one of the most highly regarded and expertly designed C++ library projects in the world. — Herb Sutter and Andrei Alexandrescu, C++ Coding Standards

This is the documentation for an old version of Boost. Click here to view this page for the latest version.

Chapter 1. Boost.MySQL

Ruben Perez

Copyright © 2019-2023 Ruben Perez

Distributed under the Boost Software License, Version 1.0. (See accompanying file LICENSE_1_0.txt or copy at http://www.boost.org/LICENSE_1_0.txt)

Table of Contents

Introduction

Motivation
When to use
Requirements
Acknowledgements

Connection objects
Connection establishment
Text queries and prepared statements
Resultsets
Rows and fields
Using fields
Using prepared statements
Multi-function operations
Error handling
Asynchronous functions

Text queries

Prepared statements

Multi-function operations

field_view vs field
Arithmetic types
String types
Blob types
The DATE type
The DATETIME and TIMESTAMP types
The TIME type
Field accessors
MySQL to C++ type mappings
C++ to MySQL type mapping reference

Going async

Single outstanding operation per connection
Completion tokens
Default completion tokens
Cancellations and timeouts

SSL-enabled streams
When is the SSL handshake performed?
SSL negotiation

UNIX sockets and other stream types

Error handling and available overloads

Handshake parameters

Authentication
Connect with database
Connection encoding and collation
SSL/TLS

Reconnecting a MySQL connection

Character sets

Character set refresher
The connection character set and collation
character_set_results and character_set_client

Setup
Text queries
Prepared statements
Metadata
UNIX sockets
Async functions using callbacks
Async functions using futures
Async functions using stackful coroutines
Async functions using C++20 coroutines
Async functions using default completion tokens
Timeouts
Setting SSL options

Building and running the tests