CentOS下MySQL怎么查看表结构

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

查看表结构：

#include
#include
#include

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

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