MySQL连接取值

#include <mysql.h>  
#include <stdio.h>  
int main()
{  
  MYSQL mysql; // need a instance to init  
  MYSQL_RES *res;  
  MYSQL_ROW row;  
  char *query;  
  int t,r;  
  mysql_init(&mysql);  
  if(!mysql_real_connect(&mysql,"localhost", "username", "password", "test",0,NULL,0))  
   {  
     printf( "Error connecting to database: %s\n",mysql_error(&mysql));  
    }  
  else  
     printf("Connected...\n");  
   
  query = "select * from t1";  
   
  t = mysql_real_query(&mysql,query,(unsigned int) strlen(query));  
  if (t)  
  {  
   printf("Error making query: %s\n",  
   mysql_error(&mysql));  
  }  
  else
   printf("[%s] made...\n", query);  
 
  res = mysql_store_result(&mysql);  
  while(row = mysql_fetch_row(res))  
   {  
    for(t=0;t<mysql_num_fields(res);t++)  
       printf("%s ",row[t]);  
 
    printf("\n");  
  }  
   
  printf("mysql_free_result...\n");  
  mysql_free_result(res); 
   
  mysql_close(&mysql);  
   
  return 0;  
}  
   
  test数据库和t1表均已建立.用如下命令编译:  
  gcc -o testsql testsql.c -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient