Hi,
I'm sometimes experiencing in my application the "commands out of sync; You
can't run this command now" error.
According to the MySQL manuel, it means :
This can happen, for example, if you are using mysql_use_result() and try to
execute a new query before you have called mysql_free_result().
hi,
I execute two check command using C, it report "Command out of sync
error".
the original statement is as below:
sprintf(ls_sql, "check table aa");
mysql_real_query(dbfd, ls_sql, strlen(ls_sql));
num = mysql_affected_rows(dbfd);
sprintf(ls_sql, "check table bb");
mysql_real_qu