mysql_field_count

mysql_field_count returns the number of columns in the most recent query result for a MariaDB connection, useful for checking whether a result set is available.

Syntax

unsigned int mysql_field_count(MYSQL * mysql);

Parameter

• mysql - a mysql handle, which was previously allocated by mysql_init() or mysql_real_connect().

Description

Returns the number of columns for the most recent query on the connection represented by the link parameter as an unsigned integer. This function can be useful when using the mysql_store_result() function to determine if the query should have produced a non-empty result set or not without knowing the nature of the query.

Return Value

The number of columns for the most recent statement. The value is zero, if the statement didn't produce a result set.

The mysql_field_count() function should be used to determine if there is a result set available.

See Also

• mysql_store_result()

• mysql_use_result()

_{This page is: Copyright © 2026 MariaDB. All rights reserved.}