我对C是新手,但我目前正在做一个项目,在这个项目中,我有一个编译器警告,但我看不出问题是什么,也看不出我是如何修复它的。
我正在执行mysql查询,然后存储结果,但是当我尝试获取要存储在MYSQL_ROW中的行时,会得到以下编译警告
警告:来自不兼容指针类型的分配
下面是我如何运行查询和存储结果
int processDrilldownData(char **reportParameterArray, FILE *csvFile, char *sql, MYSQL *HandleDB, MYSQL_RES *resultReport, MYSQL_ROW rowReport, int UserLevel, int ParentUserLevel, char *CustomerDisplayName, Restrictions *reportRestrictions, int totalLookupNumberCount, numberLookupStruct *numberLookup, int maximumLookupChars, char * statsOutputTable, int targetNumber, FILE * sqlDebugFile)
{
MYSQL_RES * audioResult = NULL;
MYSQL_ROW * audioRow = NULL;
sqlLen = asprintf(&sql, "SELECT Tmp.SwitchID, Tmp.CorrelationID, SUM(IF(Direction=2,1,0)) as SSPAudio, "
"SUM(IF(Direction=1,Duration/100,0)) as SSPAudioDur FROM %s AS Tmp GROUP BY Tmp.SwitchID, "
"Tmp.CorrelationID ORDER BY Tmp.SwitchID, Tmp.CorrelationID, Direction, SeizeUTC, SeizeCSec",
statsOutputTable);
if ((mysql_real_query(HandleDB, sql, sqlLen))) return 1;
audioResult = mysql_store_result(HandleDB);
audioRow = mysql_fetch_row(audioResult);
}谢谢你能提供的任何帮助
发布于 2013-11-22 16:38:22
错误消息来自mysql_fetch_row()而不是mysql_store_result()。mysql_fetch_row返回MYSQL_ROW,注意缺少的*。
所以声明必须看起来像
MYSQL_ROW audioRow;https://stackoverflow.com/questions/20149608
复制相似问题