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

MYSQL DbObj;//handle
MYSQL_RES *pRes;//results
MYSQL_ROW sqlrow;//rows
MYSQL_FIELD *field;

int main()
{
    char tmp[255];
    mysql_init(&DbObj);

    if (!mysql_real_connect(&DbObj, "127.0.0.1", "root", "", "test", 3306, NULL, 0)) 
    {
	return 0;
    }
    
    sprintf(tmp, "select * from v1");
    int res = mysql_query(&DbObj, tmp);
    pRes = mysql_use_result(&DbObj); 
    
    while(field = mysql_fetch_field(pRes))
	{
		printf("field table %s, org_table %s\n", field->table, field->org_table);
	}
    
	mysql_free_result(pRes);

    mysql_close(&DbObj);
    	
    return 0;
}