C API Datatypes
Here is a list of C API datatypes from the mysql.h header file:
-
MYSQL
A database handle structure created by
mysql_init( )
and released withmysql_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 using 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 includename
,table
, anddef
for 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 withmysql_row_seek( )
.-
my_ulonglong
A variable type for storing the number of rows for functions such as
mysql_affected_rows( )
,mysql_num_rows( )
, andmysql_insert_id( )
. To print the value of a variable using this type, the value should be copied to another variable that uses the unsigned long type.
Get MySQL in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.