CentOS下MySQL怎么查看表結(jié)構(gòu)

本篇內(nèi)容主要講解“CentOS下MySQL怎么查看表結(jié)構(gòu)”，感興趣的朋友不妨來看看。本文介紹的方法操作簡單快捷，實用性強。下面就讓小編來帶大家學(xué)習(xí)“CentOS下MySQL怎么查看表結(jié)構(gòu)”吧!

查看表結(jié)構(gòu)：

#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怎么查看表結(jié)構(gòu)”有了更深的了解，不妨來實際操作一番吧！這里是億速云網(wǎng)站，更多相關(guān)內(nèi)容可以進入相關(guān)頻道進行查詢，關(guān)注我們，繼續(xù)學(xué)習(xí)！