#pragma comment(lib,"libmysql.lib")

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

MYSQL mysql;
MYSQL_RES *res;
MYSQL_ROW row;

void exiterr (int exitcode) {
	fprintf(stderr, "%s\n", mysql_error(&mysql));
	exit(exitcode);
}

int main () {
	unsigned int i = 0;

	mysql_init(&mysql);

	if (!mysql_real_connect(&mysql, "localhost", "root", "!root!", "test", 0, NULL, 0)) exiterr(1);
	if (mysql_query(&mysql, "SELECT name,rate FROM emp_master")) exiterr(3);
	if (!(res = mysql_store_result(&mysql))) exiterr(4);

	while((row = mysql_fetch_row(res)))
		for (i=0 ; i < mysql_num_fields(res); i++)
			printf("%s\n", row[i]);

	if (!mysql_eof(res)) exiterr(5);

	mysql_free_result(res);
	mysql_close(&mysql);

	return 0;
}