C语言连接mysql

#include<unistd.h>
#include<stdio.h>
#include<stdlib.h>
#include<mysql/mysql.h>
int main()
{
    MYSQL selection;
    MYSQL_ROW myrow;
    MYSQL_RES *result;//结果指针
    int value,i;
    mysql_init(&selection); //初始化数据库
   if( mysql_real_connect(&selection,"localhost","database","password","table",0,NULL,0))//连接数据库
   {
        printf("connect success !");
        value=mysql_query(&selection,"select * from children");//读数据库进行操作，如果成功返回0
        if(!value)
        {
            result=mysql_store_result(&selection);//获取结果
            value=mysql_field_count(&selection);//获取字段数
           while(myrow=mysql_fetch_row(result))//获取下一行数据
           {
              for(i=0;i<value;i++)
              printf("%s    ",myrow[i]);//打印对应的每个字段
              printf("\n");
           }
           mysql_free_result(result);//释放结果指针
           mysql_close(&selection);//关闭数据库
        }
   }else
   {
      fprintf(stderr,"error ! %lu : %s",mysql_errno(&selection),mysql_error(&selection));
   }
   exit(EXIT_SUCCESS);
}