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

int main ()
{
    MYSQL       conn;

    mysql_init (&conn);
    if (!mysql_real_connect (
        &conn,
//        "127.0.0.1",
		"host",
        "user",
		//"",
        "password",
        "",
        //3350,
		33051,
        NULL,
        CLIENT_FOUND_ROWS)) {
		fprintf(stderr, "Failed to connect to database: Error: %s\n",
        mysql_error(&conn));
		return 1;
	} else {
		printf("%s\n", mysql_error(&conn));
	}
	
	int 		OK;
	
	const char* query = "drop database if exists bug29692";
	
	OK = mysql_real_query (&conn, query, strlen(query));
	
	assert(0 == OK);
	
	const char* query2 = "create database bug29692";
	
	OK = mysql_real_query (&conn, query2, strlen(query2));
	
	assert(0 == OK);
	
	const char* query3 = "CREATE TABLE bug29692.temp(value INT)";
	
	OK = mysql_real_query (&conn, query3, strlen(query3));
	
	assert(0 == OK);
	
	const char* query4 = "INSERT INTO bug29692.temp SET Value=54";

	OK = mysql_real_query (&conn, query4, strlen(query4));

	assert(0 == OK);
	
	printf("%ld rows inserted\n",
   (long) mysql_affected_rows(&conn));
	
	const char* query5 = "UPDATE bug29692.temp SET Value=55";

	OK = mysql_real_query (&conn, query5, strlen(query5));

	assert(0 == OK);
	
	printf("%ld rows updated\n",
   (long) mysql_affected_rows(&conn));
	
 	return 0;
};