Documentation Home
MySQL 9.5 C API Developer Guide
Download this Manual
PDF (US Ltr) - 1.4Mb
PDF (A4) - 1.4Mb


5.4.20 mysql_fetch_fields()

MYSQL_FIELD *mysql_fetch_fields(MYSQL_RES *result)

Description

Returns an array of allMYSQL_FIELD structures for a result set. Each structure provides the field definition for one column of the result set.

For metadata-optional connections, this function returnsNULL when theresultset_metadata system variable is set toNONE. To check whether a result set has metadata, use themysql_result_metadata() function. For details about managing result set metadata transfer, seeSection 3.6.7, “Optional Result Set Metadata”.

Return Values

An array ofMYSQL_FIELD structures for all columns of a result set.NULL if the result set has no metadata.

Errors

None.

Example

unsigned int num_fields;unsigned int i;MYSQL_FIELD *fields;num_fields = mysql_num_fields(result);fields = mysql_fetch_fields(result);for(i = 0; i < num_fields; i++){   printf("Field %u is %s\n", i, fields[i].name);}