Sams Teach Yourself MySQL in 21 Days, Second Edition

Datatypes

When you create a C program that uses the API for MySQL, you will need to include the mysql.h header file. By doing so, a number of MySQL datatypes become available that are representative of the data you will handle during the interaction with a MySQL server.

The datatypes include representations for

• A database connection

• An entire resultset of data

• A single row of data from a resultset

• Information about field descriptions

• A number of rows (for example, how many rows were affected or returned by a query)

Table 13.1 shows the API's datatypes.

Table 13.1. The C API Datatypes for MySQL

Datatype	Description
MYSQL	Used for almost all MySQL interaction, this datatype represents a database connection handle.
MYSQL_RES	Represents the resultset of any ...