#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",
        "root",
		//"",
        "svetasveta",
        "",
        //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);
	
	MYSQL_STMT    *stmt1, *stmt2;
	
	const char* query4 = "INSERT INTO bug29692.temp SET Value=54";

	stmt1 = mysql_stmt_init(&conn);
	OK = mysql_stmt_prepare(stmt1, query4, strlen(query4));

	assert(0 == OK);
	
	OK = mysql_stmt_execute(stmt1);

	assert(0 == OK);

	int affected_rows= mysql_stmt_affected_rows(stmt1);
	printf("rows inserted: %d\n", affected_rows);
	
	OK = mysql_stmt_close(stmt1);

	const char* query5 = "UPDATE bug29692.temp SET Value=55";

	stmt2 = mysql_stmt_init(&conn);
	OK = mysql_stmt_prepare(stmt2, query5, strlen(query5));

	assert(0 == OK);
	
	OK = mysql_stmt_execute(stmt2);

	assert(0 == OK);

	affected_rows= mysql_stmt_affected_rows(stmt2);
	printf("rows updated: %d\n", affected_rows);
	
	OK = mysql_stmt_close(stmt2);

 	return 0;
};