查询某一字段最小值的语句可以使用MIN()函数，例如：
SELECT MIN(field) FROM mytable;
在C语言接口中，可以通过mysql_fetch_row函数获取查询结果，然后判断第一列是否为NULL或者查询结果集行数是否为0。以下是示例代码：
MYSQL_RES *result;
MYSQL_ROW row;
// 执行查询语句
if (mysql_query(&mysql, "SELECT MIN(field) FROM mytable")) {
printf("Query failed: %s\n", mysql_error(&mysql));
return;
}
// 获取查询结果集
result = mysql_store_result(&mysql);
// 判断查询结果是否为空
if (mysql_num_rows(result) == 0 || (row = mysql_fetch_row(result)) == NULL || row[0] == NULL) {
printf("Query result is empty.\n");
} else {
printf("The minimum value is %s.\n", row[0]);
}
// 释放结果集
mysql_free_result(result);
![5-01-15T13:58:44+08:00 [FATA][LIB][MonDB] server selection error: server selection timeout, current topology: { Type: Unknown, Servers: [{ Addr: 127.0.0.1:27017, Type: Unknown, Last error: connection() error occured during connection handshake: di...](https://linuxcpp.0voice.com/zb_users/upload/2023/05/202305162215397523846.png)
