mysql_query(&zhqy,"select * from shop")时 报错Commands out of sync
连接成功,但是mysql_query(&zhqy,"select * from shop");时报错,数据库存在,
而且如果mysql_query(&zhqy,"use zhqy");可以
[code=C/C++][
MYSQL zhqy;
if (0 == mysql_init(&zhqy))
{
fprintf(stderr,"mysql init for zhqy %s\n",mysql_error(&zhqy));
return 1;
}
if (0 == mysql_real_connect(&zhqy,"localhost","root",NULL,"zhqy",0,NULL,0))
{
fprintf(stderr,"mysql connect for zhqy %s\n",mysql_error(&zhqy));
return 1;
}
if(0 !=mysql_query(&zhqy,"select * from shop"))
fprintf(stderr,"query error: %s\n",mysql_error(&zhqy));
/code]