C操作mysql

#if defined(_WIN32) || defined(_WIN64) //为了支持windows平台上的编译
#include <windows.h>
#endif
#include <stdio.h>
#include<string.h>
#include <stdlib.h>
#include "mysql.h"  //我的机器上该文件在/usr/local/include/mysql下
//定义数据库操作的宏，也可以不定义留着后面直接写进代码
#define SELECT_QUERY "select * from user where User='root'"

int main(int argc, char **argv) //char **argv 相当于 char *argv[]
{
	MYSQL mysql,*sock;    //定义数据库连接的句柄，它被用于几乎所有的MySQL函数
	MYSQL_RES *res;       //查询结果集，结构类型
	MYSQL_FIELD *fd ;     //包含字段信息的结构
	MYSQL_ROW row ;       //存放一行查询结果的字符串数组
	char qbuf[160];      //存放查询sql语句字符串
	mysql_init(&mysql);
	if (!(sock = mysql_real_connect(&mysql,"localhost","root","1","mysql",0,NULL,0))) {
		fprintf(stderr,"Couldn't connect to engine!\n%s\n\n",mysql_error(&mysql));
		perror("");
		exit(1);
	}   
	sprintf(qbuf,SELECT_QUERY);
	if(mysql_query(sock,qbuf)) {
		fprintf(stderr,"Query failed (%s)\n",mysql_error(sock));
		exit(1);
	}    
	if (!(res=mysql_store_result(sock))) {
		fprintf(stderr,"Couldn't get result from %s\n", mysql_error(sock));
		exit(1);
	}    
	printf("number of fields returned: %d\n",mysql_num_fields(res));

	while (row = mysql_fetch_row(res)) {
		printf("Ther root's Host is: %s\n",(((row[0]==NULL)&&(!strlen(row[0]))) ? "NULL" : row[0])) ;
		//puts( "query ok !\n" ) ;
	}

	mysql_free_result(res);
	mysql_close(sock);
	exit(0);
	return 0;   //. 为了兼容大部分的编译器加入此行
}

编译：gcc -g -o x ./x.c -I/usr/include/mysql -L/usr/local/lib/mysql -lmysqlclient
 如果是#include "/usr/include/mysql/mysql.h"就不必-I/usr/include/mysql