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);
mysql下面获取数据库的列数和列的名字的sql语句
最新推荐文章于 2022-01-19 11:43:24 发布