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

#define SELECT1 "SELECT CONCAT('Hund', `addresses`.`Country`) AS `Result` FROM `customers2addresses` INNER JOIN `addresses` ON (`customers2addresses`.`AddressID` = `addresses`.`ID`)"
#define SELECT2 "SELECT CONCAT('Hund', `addresses`.`Country`) AS `Result` FROM `customers2addresses` INNER JOIN `addresses` ON (`customers2addresses`.`AddressID` = `addresses`.`ID`) ORDER BY `addresses`.`ID`"

int main()
{
  MYSQL *conn;
  MYSQL_RES *meta;
  MYSQL_FIELD *field;
  MYSQL_BIND bind = {0};
  int res;
  unsigned long len;
  char buf[21] = {0};
  double d=-1.0;

  conn= mysql_init(NULL);
  conn= mysql_real_connect(conn, "192.168.104.1", "GoferUser", "Gofer", "Addresses", 3306, 0, 0);
  if (!conn) {
    fprintf(stderr, "Cannot connect\n");
    exit(1);
  }

  printf("Client info: %s\n", mysql_get_client_info());
  printf("Server info: %s\n", mysql_get_server_info(conn));

  res= mysql_query(conn, SELECT1);
  meta = mysql_store_result(conn);
  field = mysql_fetch_field(meta);

  printf("type=%d\n", field->type);
  printf("length=%d\n", field->length);
  printf("decimals=%d\n", field->decimals);
  mysql_free_result(meta);

  res= mysql_query(conn, SELECT2);
  meta = mysql_store_result(conn);
  field = mysql_fetch_field(meta);

  printf("type=%d\n", field->type);
  printf("length=%d\n", field->length);
  printf("decimals=%d\n", field->decimals);
  mysql_free_result(meta);

  mysql_close(conn);
  return 0;
}