c mysql 列_MySQL C API - 按列名访问行

C并不真正支持关键值数组，例如(我假设你的想法)PHP。您可以获得的最接近的事情是获取列名称数组，搜索您需要的列名称，并使用该索引。例如：

mysql_query(_MySQLConnection, query);

MYSQL_RES *result = mysql_store_result(_MySQLConnection);

unsigned int num_fields = mysql_num_fields(result);

MYSQL_ROW row;

MYSQL_FIELD *field;

unsigned int name_field;

char *field_name = "name";

char *headers[num_fields];

for(unsigned int i = 0; (field = mysql_fetch_field(result)); i++) {

headers[i] = field->name;

if (strcmp(field_name, headers[i]) == 0) {

name_field = i;

}

}

while ((row = mysql_fetch_row(result))) {

//do something with row[name_field]

printf("Name: %s\n", row[name_field]);

}

mysql_free_result(result);