#include <stdio.h>
#include <mysql.h>

#define THE_QUERY "select CalendarDate from (select max(now()) CalendarDate from demo) a"

void chk(MYSQL *m)
{
  if (mysql_errno(m) !=0)
    {
      printf("Error %s",mysql_error(m));
      exit(1);
    }
}

int main()
{
  MYSQL mysql;
  MYSQL_RES *r;
  MYSQL_FIELD *fld;

  mysql_init(&mysql); chk(&mysql);
  mysql_real_connect(&mysql,NULL,"root","","test",0,NULL,0);chk(&mysql);
  
  mysql_query(&mysql,THE_QUERY);chk(&mysql);
  r=mysql_use_result(&mysql);
  fld = mysql_fetch_field(r);
  printf("column: name %s, length %lu type %d\n",fld->name, fld->length,(int)fld->type); 
  

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