c语言mysql查询数据库

#include<stdio.h>
#include<string.h>
#include<mysql.h>
int main()
{
	MYSQL mysql;
	MYSQL_RES *res=NULL;
	MYSQL_ROW row;
	
	MYSQL_FIELD  *fields;                              //保存字段名字信息
	unsigned int  num_fields;
	unsigned int  i;
	char query[1024];
	int flag,t,r;
	int serviceID=3;
	char test[1024];
	mysql_init(&mysql);
        //根据需要修改连接信息
        if(!mysql_real_connect(&mysql,"targetIP","username","passwd","databaseName",0,NULL,0))
	{
		printf("Error connecting to database \n");
		return 0;
	}
	else
	
	printf("Connected MYSQL successfully!\n");
	memset(query,'\0',1024);
	sprintf(query,"select SERVICE_ID,NAME from XXXX where SERVICE_ID !=%d",serviceID);
	flag=mysql_real_query(&mysql,query,(unsigned int)strlen(query));
	if(flag)
	/*failure*/	
	{
		printf("query failed! \n");
		return 0;
	}
	else
	{
		res=mysql_store_result(&mysql);
		//输入内容的title
		num_fields = mysql_num_fields(res);             //获取查询结果中，字段的个数
		fields = mysql_fetch_fields(res);               //获取查询结果中，各个字段的名字
		for(i = 0; i < num_fields;i++)
		{
      			 printf("结果字段%u是：  %s\n",i,fields[i].name);
		}
		
		//输入内容的行数
		
		printf("Number of rows %lu\n",(unsigned long)mysql_num_rows(res));
		if((unsigned long)mysql_num_rows(res)>1024)
		{	
			printf("MAXIPLIST is not enough！\n");
			return 0;
		}		

		while(row=mysql_fetch_row(res))
		{
			//for(t=0;t<mysql_num_fields(res);t++)
			//{	
				
				printf("ServiceId is %s\n   ",row[0]);
			        strcpy(test,row[1]);
				printf("Name is %s",test);
							
			//}
		printf("\n");
		}

		mysql_free_result(res);
		mysql_close(&mysql);
		return 0;
	}
}