MySQL in a Nutshell, 2nd Edition

C API Datatypes

Here is a list of C API data types from the mysql.h header file:

MYSQL

A database handle structure created by mysql_init() and released with mysql_close().

MYSQL_RES

A structure for a results set from an SQL query. This structure is used by fetch functions and is released with mysql_free_result().

MYSQL_ROW

A structure for holding a row of data from a results set. The data is retrieved from this structure by the mysql_fetch_row() function.

MYSQL_FIELD

A structure for holding an array of information about a field of a results set. The array may be set with the mysql_fetch_field() function. The elements include name, table, and def for the default value.

MYSQL_FIELD_OFFSET

Used for recording a pointer location for a results set. The offset value can be retrieved by the mysql_row_tell() function and deployed with mysql_row_seek().

my_ulonglong

A variable type for storing the number of rows for functions such as mysql_affected_rows(), mysql_num_rows(), and mysql_insert_id(). To print the value of a variable using this type, copy the value to another variable that uses the unsigned long type.