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
mysql数据库怎么取列数_mysql下面获取数据库的列数和列的名字的sql语句
最新推荐文章于 2021-07-27 14:57:26 发布