http://dev.mysql.com/doc/refman/5.0/en/c-api-multiple-queries.html参考:
http://sswin0922.blog.163.com/blog/static/95115415201002554341619/加上CLIENT_MULTI_STATEMENTS 试试
http://sswin0922.blog.163.com/blog/static/95115415201002554341619/加上CLIENT_MULTI_STATEMENTS 试试
printf("real_query failed\n");
printf("%s\n", mysql_error(&m));
mysql_close(&m);
exit(1);
}
MYSQL_RES *res= mysql_store_result(&m);
MYSQL_ROW row;
while ((row = mysql_fetch_row(res))) {
printf("id is %d, name is %s\n", atoi(row[0]), row[1]);
}
mysql_free_result(res);
if (mysql_next_result(&m)) {
printf("next failed\n");
printf("%s\n", mysql_error(&m));
mysql_close(&m);
exit(1);
}
if (mysql_query(&m, "select @a")) {
printf("query failed\n");
printf("%s\n", mysql_error(&m));
mysql_close(&m);
exit(1);
}
mysql_next 确实返回0了,但是下次调用store出来确实为空,再次next才返回-1