MySQL :: MySQL 8.4 C API Developer Guide :: 5.4.19 mysql_fetch_field_direct() (original) (raw)

The world's most popular open source database

5.4.19 mysql_fetch_field_direct()

MYSQL_FIELD *
mysql_fetch_field_direct(MYSQL_RES *result,
                         unsigned int fieldnr)

Description

Given a field number fieldnr for a column within a result set, returns that column's field definition as a MYSQL_FIELD structure. Use this function to retrieve the definition for an arbitrary column. Specify a value for fieldnr in the range from 0 tomysql_num_fields(result)-1.

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

Return Values

The MYSQL_FIELD structure for the specified column. NULL if the result set has no metadata.

Example

unsigned int num_fields;
unsigned int i;
MYSQL_FIELD *field;

num_fields = mysql_num_fields(result);
for(i = 0; i < num_fields; i++)
{
    field = mysql_fetch_field_direct(result, i);
    printf("Field %u is %s\n", i, field->name);
}