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

const char* myUser = "root";
const char* myPwd = "";
const char* mySocket = "/var/mysql/50/mysql.sock";
const char* myDb = "test";

int main()
{
    MYSQL *mysql;
    MYSQL_STMT *st;
    const char* query = "SELECT COUNT(*) FROM t1 where 1 = 0";
    int ret;
    unsigned long type;

    mysql = mysql_init(NULL);
    mysql_real_connect(mysql,NULL,myUser,myPwd,myDb,0,mySocket,0);

    st = mysql_stmt_init(mysql);
    type = (unsigned long)CURSOR_TYPE_READ_ONLY;
    ret = mysql_stmt_attr_set(st,STMT_ATTR_CURSOR_TYPE,(void*)&type);
    ret = mysql_stmt_prepare(st, query, strlen(query));

    mysql_stmt_execute(st);
    ret = mysql_stmt_fetch(st);

    std::cout << "mysql_stmt_fetch returned: " << ret << std::endl;

    mysql_close(mysql);
}