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

MYSQL *mysql;
MYSQL_RES *results;
MYSQL_ROW record;
MYSQL_FIELD *field;

static char *server_options[] = { "mysql_test", "--defaults-file=my.cnf", NULL };

int num_elements = (sizeof(server_options) / sizeof(char *)) - 1;

static char *server_groups[] = { "libmysqld_server", "libmysqld_client", NULL };

int main(void)
{
	int j=0;
	int width=0;

	mysql_library_init(num_elements, server_options, server_groups);
	mysql = mysql_init(NULL);
	mysql_options(mysql, MYSQL_READ_DEFAULT_GROUP, "libmysqld_client");
	mysql_options(mysql, MYSQL_OPT_USE_EMBEDDED_CONNECTION, NULL);

	mysql_real_connect(mysql, "XXXXXXXXXXXXXXXXXXXXX","YYYY",NULL, "ZZZZZZZZZZ", 0,NULL,0);

	mysql_query(mysql, "SELECT * FROM mtTable LEFT JOIN (SELECT * FROM mtTable_record) AS new_table ON mtTable.id=new_table.id_mtTable");

	results = mysql_store_result(mysql);
	width = mysql_num_fields(results);

	mysql_field_seek(results, 0);
	for( j=0; field = mysql_fetch_field(results), j<width; j++) {

		printf("j=%d field_table=[%s] field_org_table=[%s] field_name=[%s] field_org_name=[%s] def=[%s]\n", j, 
			field->table?field->table:"<null>", field->org_table?field->org_table:"<null>", 
			field->name?field->name:"<null>", field->org_name?field->org_name:"<null>", field->def?field->def:"<null>");
	}

	mysql_free_result(results);
	mysql_close(mysql);
	mysql_library_end();

	return 0;
}