mysql* m_pstconn;//为已建立的 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);
}
,