#include <stdlib.h>
#include <stdio.h>
#include <WinSock.h>
#include <Windows.h>
#include <mysql.h>

#pragma comment(lib, "libmysql.lib")

int main()
{
      MYSQL mysql;     //mysql连接
      MYSQL_RES *res; //这个结构代表返回行的一个查询结果集
      MYSQL_ROW row; //一个行数据的类型安全(type-safe)的表示
      char *query;  //查询语句
      int t,r;
      mysql_init(&mysql);

     
      if (!mysql_real_connect(&mysql,"localhost", "root", "", "test",3306,NULL,0))
      {
         printf( "Error connecting to database: %s\n",mysql_error(&mysql));
      }  else
         printf("Connected\n");
    
     
      query="SET CHARACTER SET GBK"; //设置编码
      t=mysql_real_query(&mysql,query,(unsigned int)strlen(query));
      if(t)
      {
           printf("编码设置失败\n");
      }
      query=" select * from abing ";
      t=mysql_real_query(&mysql,query,(unsigned int)strlen(query));
      if(t)
      {
          printf("执行查询时出现异常: %s",mysql_error(&mysql));
         
      }else
          printf("[%s] 构建成功 \n",query);
      res=mysql_store_result(&mysql);
      while(row=mysql_fetch_row(res))
      {                             
           for(t=0;t<mysql_num_fields(res);t++)
           {
               printf("%s\t",row[t]);
           }
           printf("\n");
      }
      mysql_free_result(res);
}