#include <stdio.h>
#include <iostream.h>
#include <stdlib.h>
#include <fstream.h>
#include <string.h>
#include "mysql.h"

MYSQL mysql;
MYSQL_RES *res;
MYSQL_ROW row;
bool Free = false;
void exiterr(int exitcode){
  fprintf(stderr, "%s\n", mysql_error(&mysql));
  exit(exitcode);
}

int main() {
  uint i=0;


  if (!(mysql_connect(&mysql,"ipaddress","user","password")))
       exiterr(1);
    if (mysql_select_db(&mysql,"databasename"))     
	   exiterr(2); 
  
   ofstream outfile("word_list.txt");
	
    char buff[300];  
 
    Free = 0;
     	sprintf(buff,"select synset_id, synset, gloss from tbl_all_synset");
  
    if(mysql_query(&mysql,buff)){
	          return -1;
    }
	if(res = mysql_store_result(&mysql)){
         Free = 0;
    }
    else{
         Free = 1;
    }
    
	while(row = mysql_fetch_row(res)){
	  cout << row[0] << " ";
	  cout << row[1] << " ";
	  cout << row[2] << "\n";
	}
	if(Free) { 
		mysql_free_result(res);
	}
    
   outfile.close();
}