CentOS下MySQL怎么查看表结构

本篇内容主要讲解“CentOS下MySQL怎么查看表结构”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“CentOS下MySQL怎么查看表结构”吧!

查看表结构：

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

int main() { MYSQL mysql; //need a instance to init MYSQL_RES *res; MYSQL_ROW row; char *query; int t,r; //connect the database mysql_init_($mysql);
if(!mysql_real_connect(&mysql,"localhost","","","test",0,NULL,0)) {printf("Error connecting to database:%s\n", mysql_error($mysql)); } else printf("Connected ..\n"); //get the result from the executing select query query = "select * from t1"; t = mysql_real_query(&mysql,query,(unsigned int)strlen(query)); if(t)
{printf("Error making query:%s\n",mysql_error(&mysql);} else printf("[%s] made..\n",query); res = mysql_store_result(&mysql); while(row = mysql_fetch_row(res)) {for(t=0;t<mysql_num_fields(res);t++) { printf("%s",row[t]); } printf("\n");} printf("mysql_free_result...\n"); mysql_free_result(res);//free result after you get the result sleep(1); mysql_close(&mysql); return 0; }

到此，相信大家对“CentOS下MySQL怎么查看表结构”有了更深的了解，不妨来实际操作一番吧！这里是亿速云网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！