#include <mysql.h>
#include <string.h>
#include <stdio.h>
#include <assert.h>

int main ()
{
    MYSQL       conn;

    mysql_init (&conn);
    if (!mysql_real_connect (
        &conn,
        "localhost",
        "root",
        "",
        "animal",
        0,
        "/tmp/mysql50.sock",
        0)) {
		fprintf(stderr, "Failed to connect to database: Error: %s\n",
        mysql_error(&conn));
		return 1;
	} else {
		printf("%s\n", mysql_get_ssl_cipher(&conn));
	}
	
	
	MYSQL_RES* 	result;
	int 		OK;
	MYSQL_FIELD *field;
	
	const char* query = "SELECT animal.*,animalcolor.*,animalweight.* FROM animal LEFT JOIN animalcolor ON animal.IdAnimal = animalcolor.IdAnimal LEFT JOIN animalweight ON animal.IdAnimal = animalweight.IdAnimal";
	
	OK = mysql_real_query (&conn, query, strlen(query));
	
	assert(0 == OK);
	
	result = mysql_use_result(&conn);
	
	while((field = mysql_fetch_field(result))) {
		printf("%s---%s\n", field->table, field->name);
	}
	
	mysql_free_result(result);

	printf("\nError here:\n\n");
	
	const char* query2 = "SELECT animal.*,animalcolor.*,animalweight.* FROM animal LEFT JOIN animalcolor ON animal.IdAnimal = animalcolor.IdAnimal LEFT JOIN animalweight ON animal.IdAnimal = animalweight.IdAnimal order by animalcolor.Categ,animalweight.Categ";
	
	OK = mysql_real_query (&conn, query2, strlen(query2));
	
	assert(0 == OK);
	
	result = mysql_use_result(&conn);
	
	while((field = mysql_fetch_field(result))) {
		printf("%s---%s\n", field->table, field->name);
	}
	
	mysql_free_result(result);

 	return 0;
};