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

int main()
{
    MYSQL       *dbHandle     = NULL;                        /*  connect handle                  */
    MYSQL       *dbHandleTmp  = NULL;           
    MYSQL_STMT  *dbStmtHandle = NULL;                        /*  stmt    handle                  */    
    
    int         ret           = 0;                           /*  get function return value       */
    char        sqlStmt[]     = "SELECT COUNT(*) FROM tt";   /*  tt is a table in my db: ylliu1  */
    
    dbHandle = mysql_init(NULL);
    if (NULL == dbHandle) {
        printf("Init connect handle failure \n");
        
        return -1;    
    }
    
    dbHandleTmp = dbHandle;
    dbHandle = mysql_real_connect(dbHandleTmp, "localhost", "dbylliu1", "123", "ylliu1", 0, NULL, 0);
    if (NULL == dbHandle) {
        printf("connect db failure \n");
        
        mysql_close(dbHandleTmp);
        
        return -1;
    }
    
    dbStmtHandle = mysql_stmt_init(dbHandle);
    if (NULL == dbStmtHandle) {
        printf("Init Stmt Handle failure\n");
        
        mysql_close(dbHandle);
        
        return -1;
    }
    
    ret = mysql_stmt_prepare(dbStmtHandle, sqlStmt, strlen(sqlStmt));
    if (0 != ret) {
        printf("Prepare Stmt Handle failure\n");
        
        mysql_stmt_close(dbStmtHandle);
        mysql_close(dbHandle);
        
        return -1;    	
    }
    
    /*   Execute NULL stmt Handle   */
    ret = mysql_stmt_execute(NULL);
    if (0 != ret) {
        printf("Execution failure \n");

        mysql_stmt_close(dbStmtHandle);        
        mysql_close(dbHandle);
        
        return -1;
    }
    
    printf("Execution Success \n");

    mysql_stmt_close(dbStmtHandle);        
    mysql_close(dbHandle);   
         
    return 0;
}