执行一次存储过程后,mysql_real_query再执行其他sql语句的时候,总是提示
Commands out of sync; you can't run this command now;
解决办法,代码片段:
if (0 != mysql_real_query(mysql_Conn, sql, (unsigned long)strlen(sql)))
{
setError();
}
do
{
mysql_res = mysql_store_result(mysql_Conn);
if (!mysql_res)
{
mysql_free_result(mysql_res);
continue;
}
mysql_free_result(mysql_res);
} while (0 == mysql_next_result(mysql_Conn);