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

int main(int argc, char **argv) {
  MYSQL *mysql = NULL;
  MYSQL_RES *res;
  MYSQL_ROW row;
  char query[1024];

  mysql = mysql_init(mysql);
  if(!mysql_real_connect(mysql, "localhost", "hfisk", "", "world", 0, NULL, 0)) {
    printf("Couldn't connect to MySQL! (%s)\n", mysql_error(mysql));
    exit(1);
  }

  sprintf(query,"SELECT code, name, population FROM Country WHERE Region like 'Nordic%%' AND Population > 1000000");

  if(!mysql_real_query(mysql, query, strlen(query))) {
    res = mysql_store_result(mysql);
    printf("code\tname\tpopulation\n----\t-----\t----------\n");
    if(res) while((row = mysql_fetch_row(res)))
      printf("%s\t%s\t%10i\n", row[0], row[1], atoi(row[2]));
    mysql_free_result(res);
  }

  mysql_close(mysql);
  return(0);
}