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


	int main()
{
	MYSQL * tmp;
	MYSQL * mysql = NULL;
	MYSQL_RES * mysql_result;
	MYSQL_ROW mysql_row;
	
	unsigned long *lengths;
	unsigned int num_fields;
	unsigned int i;	
	
	char * query = "SELECT col1, col2, col3 from log where col0index='2'";
	
	mysql = mysql_init(mysql);
	if (mysql == NULL) {
		puts("init failed");
		return -1;
	}
	
	tmp = mysql_real_connect(mysql, "localhost", "root", "", "test", 0, NULL, CLIENT_COMPRESS);
	
	if (!tmp) {
		printf("connect failed: %s\n", mysql_error(mysql));
		exit(3);
	}

    if(mysql_query(mysql, query)) {
		printf("Query failed: %s\n", mysql_error(mysql));
		exit(3);
	} else {
		puts("Query OK");
	}
	
	
	mysql_result=mysql_use_result(mysql);
	
	if (mysql_result==NULL) {
		puts("no result");
		return -1;
	}

	mysql_row=mysql_fetch_row(mysql_result);
	if(mysql_row == NULL) {
		puts("no result");
		return -1;
	}

	if (mysql_row!=NULL)
	{ 
		num_fields = mysql_num_fields(mysql_result);
		lengths = mysql_fetch_lengths(mysql_result);
		for(i = 0; i < num_fields; i++)
		{
			printf("Column %u is %lu bytes in length.\n", i, lengths[i]);
		}
		printf("Col1: %s \nCol2: %s \nCol3: %s \n", mysql_row[0], mysql_row[1], mysql_row[2]);
	}

	return 0;
}