mysql_fetch_field() - mysql/mysql.h

 Returns the definition of one column of a result set as a
        MYSQL_FIELD structure. Call this function
        repeatedly to retrieve information about all columns in the
        result set. mysql_fetch_field()
        returns NULL when no more fields are left.MYSQL_FIELDmysql_fetch_field()mysql_fetch_field()NULLmysql_fetch_field() is reset to
        return information about the first field each time you execute a
        new SELECT query. The field
        returned by mysql_fetch_field()
        is also affected by calls to
        mysql_field_seek().mysql_fetch_field()mysql_fetch_field()SELECTSELECTmysql_fetch_field()mysql_fetch_field()mysql_field_seek()mysql_field_seek()If you've called mysql_query()
        to perform a SELECT on a table
        but have not called
        mysql_store_result(), MySQL
        returns the default blob length (8KB) if you call
        mysql_fetch_field() to ask for
        the length of a BLOB field. (The
        8KB size is chosen because MySQL does not know the maximum
        length for the BLOB. This should
        be made configurable sometime.) Once you've retrieved the result
        set, field->max_length contains the length
        of the largest value for this column in the specific query.mysql_query()mysql_query()SELECTSELECTmysql_store_result()mysql_store_result()mysql_fetch_field()mysql_fetch_field()BLOBBLOBBLOBBLOBfield->max_length

Syntax

MYSQL_FIELD *mysql_fetch_field(MYSQL_RES
        *result)

Example

MYSQL_FIELD *field;

while((field = mysql_fetch_field(result)))
{
    printf("field name %s\n", field->name);
}

Output / Return Value

 The MYSQL_FIELD structure for the current
        column. NULL if no columns are left.MYSQL_FIELDNULL

Limitations

Alternatives / See Also

Reference