C語言調用MySQL函數

MYSQL* m_pstConn;//為已建立的 MySQL資料庫連接 

// 擷取表名

 MYSQL_ROW tbl;   

MYSQL_RES * pResultSet = NULL;

pResultSet = mysql_list_tables(m_pstConn, NULL); 

while(tbl = mysql_fetch_row(pResultSet))

{
  printf("table:%s\n", tbl[0]);
 

}

//擷取資料庫名

MYSQL_ROW db; 

MYSQL_RES * pResultSet = NULL;

pResultSet = mysql_list_dbs(m_pstConn, NULL); 

while(db= mysql_fetch_row(pResultSet))
{
  printf("db:%s\n", db[0]);
 
 }

 

//擷取欄位名

MYSQL_FIELD *tbl;

MYSQL_RES * pResultSet = NULL;

pResultSet = mysql_list_fields(m_pstConn, "test_log", NULL);

while(tbl = mysql_fetch_field(pResultSet))
{
  printf("db:%s\n", tbl[0]);
 
}

 

//擷取欄位名

MYSQL_FIELD *tbl;

MYSQL_RES * pResultSet = NULL;

mysql_query(m_pstConn, "select * from test_log");

pResultSet = mysql_store_result(m_pstConn);

while(tbl = mysql_fetch_field(pResultSet))
{
  printf("db:%s\n", tbl[0]);
 }

 

//擷取欄位資訊

MYSQL_FIELD *tbl;

MYSQL_RES * pResultSet = NULL;

mysql_query(m_pstConn, "select * from test_log");

pResultSet = mysql_store_result(m_pstConn);

while(tbl = mysql_fetch_field(pResultSet))
{
  printf("db:%s, %d, %d, %s\n", tbl[0], tbl->type, tbl->flags, tbl->name);
 
}