mysql下面获取数据库的列数和列的名字的sql语句

void QueryTableInfo(MYSQL * con,char * pTableName)
{
 
 //Result where stored Queryed result
 MYSQL_RES *Res = NULL;
 //the coloume of the result
 MYSQL_ROW *Row = NULL;
 char pSql[1024]={0}; 
 int iColumnsCount = 0;
 int i = 0;
 
 //query columns count
 sprintf(pSql,"select count(*) from information_schema.columns where table_schema='%s' and table_name = '%s'",gDBInfo->DBName,pTableName);
 if(mysql_query(con,pSql))
 {
  printf ("query Columns count failed:%s/n",mysql_error(con));
  return;
 }
 Res = mysql_use_result(con);
 while(Row = (MYSQL_ROW *)mysql_fetch_row(Res))
 {
  iColumnsCount=(int)(atoi((char*)Row[0]));
 }
 mysql_free_result(Res);
 Res = NULL;
 printf("columns is %d/n",iColumnsCount);
 
 memset(pSql,0,512);
 //query columns Name and display on the screen
 sprintf(pSql,"select COLUMN_NAME from information_schema.columns where table_schema = '%s' and table_name = '%s'",gDBInfo->DBName,pTableName);
 //sprintf(pSql,"show columns from %s",pTableName);
 printf("%s",pSql);
 if(mysql_query(con,pSql))
 {
  printf("query columns Name failed:%s/n",mysql_error(con));
  return;
 }
 Res = mysql_use_result(con);
 while(Row =(MYSQL_ROW *) mysql_fetch_row(Res))
 {
  for(i=0;i<iColumnsCount;i++)
  {
   printf("%s",(char*)Row[i]);
   printf("/t/t");
  }
 }
 mysql_free_result(Res);
 Res = NULL;
 memset(pSql,0,512);
 sprintf(pSql,"select * from %s",pTableName);
 if(mysql_query(con,pSql))
 {
  printf("Query Database is failed:%s/n", mysql_error(con));
  return;
 }
 Res = mysql_use_result(con);
 while(Row = (MYSQL_ROW *)mysql_fetch_row(Res))
 {
  for(i=0;i<iColumnsCount;i++)
  {
   printf("%s",(char*)Row[i]);
   printf("/t");
  }
  printf("/n");
 }
 mysql_free_result(Res);
 mysql_close(con);