CREATE OR REPLACE TABLE t1 (a INT DEFAULT NULL);

CREATE OR REPLACE VIEW v1 AS SELECT a FROM t1;

#if defined(_WIN32) || defined(WIN32) || defined(_WIN64)

#include <windows.h>

#endif

#include <stdio.h>

#include <stdlib.h>

#include "mysql.h"

int main(int argc, char **argv)

{

  MYSQL mysql,*sock;

  MYSQL_RES *res;

  MYSQL_FIELD *sql_field;

  mysql_init(&mysql);

  if (!(sock = mysql_real_connect(&mysql, "localhost", "root", NULL,

                                  "test", 0, "/tmp/mysql.sock", 0)))

  {

    fprintf(stderr,"mysql_real_connect failed: %s\n",mysql_error(&mysql));

    return 1;

  }

  res= mysql_list_fields(&mysql, "v1", NULL);

  if (!res)

  {

    fprintf(stderr, "res is NULL\n");

    return 1;

  }

  while ((sql_field= mysql_fetch_field(res)))

  {

    printf("DB: %s Table: %s Column name: %s Type: %d Default: %s Decimals: %d\n",

          sql_field->db,

          sql_field->table,

          sql_field->name,

          sql_field->type,

          sql_field->def,

          sql_field->decimals);

  }

  mysql_free_result(res);

  mysql_close(sock);

  return 0;

}

DB: test Table: v1 Column name: a Type: 3 Default: 0 Decimals: 0