//MYSQL_RES保存查询结构
MYSQL_RES* result_ = NULL;
//对mysql数据库进行查询操作:
MYSQL_ROW row;
char query_sql[1024] = "select *from db.table where (wb_mid ='"; //构建查询sql语句
strcat(query_sql,mid); //db为数据库名,table为表名 where后为判断语句
strcat(query_sql,"')");
//执行sql查询
if(mysql_query(&my_connection,query_sql) == 0)
{
//查询成功,保存查询结果
result_ = mysql_store_result(&my_connection);
//获取查询出来的结果,即遍历查询到的每一行记录
row = mysql_fetch_row(result_);
printf("%s\n",row[14]);
mysql_free_result(result_);
}
MYSQL_RES* result_ = NULL;
//对mysql数据库进行查询操作:
MYSQL_ROW row;
char query_sql[1024] = "select *from db.table where (wb_mid ='"; //构建查询sql语句
strcat(query_sql,mid); //db为数据库名,table为表名 where后为判断语句
strcat(query_sql,"')");
//执行sql查询
if(mysql_query(&my_connection,query_sql) == 0)
{
//查询成功,保存查询结果
result_ = mysql_store_result(&my_connection);
//获取查询出来的结果,即遍历查询到的每一行记录
row = mysql_fetch_row(result_);
printf("%s\n",row[14]);
mysql_free_result(result_);
}