#include <stdio.h>
#include <string.h>
#include <winsock2.h>
#include <mysql.h>
int main()
{
MYSQL mysql;
MYSQL_RES *res;
MYSQL_ROW row;
char query[1024];
mysql_init(&mysql);
if(!mysql_real_connect(&mysql, "localhost", "root", "123456", "aaa", 3306, NULL, 0))
{
printf("connect error!/n");
}
else
{
printf("connect success!/n");
strcpy(query," select * from aa;");
mysql_real_query(&mysql,query,(unsigned long)strlen(query));
res=mysql_store_result(&mysql);
if(res==NULL)
{
printf("结果为空/n");
}
else
{
printf("%lu/n/n",(unsigned long)mysql_num_rows(res));
while((row=mysql_fetch_row(res)))
{
printf("%s/n",row[0]);
}
}
mysql_free_result(res);
}
mysql_close(&mysql);
return 0;
}