my_bool res = mysql_ping(c->mysql);
if (res) {
    mysql_close(c->mysql);
    mysql_thread_end();

    c->mysql = mysql_init(NULL);
    mysql_thread_init();                

    struct conn_desc *cd = &c->db->cds[c->num];
    syslog(LOG_ERR, "reconnect :[%s:%d]\t%s\tnew MySQL=%X tid=%X\n", cd->host,  cd->port, c->db->default_db_name, c->mysql, pthread_self());

    res = mysql_real_connect(c->mysql, cd->host, cd->login, cd->passwd, c->db->default_db_name, cd->port, NULL, 0);
    if (res == NULL) {
        syslog(LOG_ERR, "[restart ] reconnect Error\n");
        exit(1);
    }
}

mysql> describe log;
+--------------+------------------+------+-----+---------+----------------+
| Field        | Type             | Null | Key | Default | Extra          |
+--------------+------------------+------+-----+---------+----------------+
| id           | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| machine      | varchar(64)      | NO   | MUL | NULL    |                |
| date         | datetime         | NO   | MUL | NULL    |                |
| event        | varchar(8)       | NO   | MUL | NULL    |                |
| netid        | varchar(16)      | NO   | MUL | NULL    |                |
| domain       | varchar(32)      | NO   | MUL | NULL    |                |
| line         | varchar(64)      | NO   | MUL | NULL    |                |
| source       | varchar(8)       | NO   | MUL | NULL    |                |
| dateInserted | datetime         | NO   | MUL | NULL    |                |
| notes        | varchar(128)     | NO   |     | NULL    |                |
+--------------+------------------+------+-----+---------+----------------+

int insertIntoDB(MYSQL *mysql, struct env PEnv, char *date, char *source) {

    char *insertSQL = "\
INSERT INTO personalDB.log \
            (id, event, machine, netid, line, source, date) \
VALUES(NULL, UPPER(?), UPPER(?), UPPER(?), UPPER(?), UPPER(?), NOW())";

    char *tmp;
    char *datePtr;

    int numBindCols = 5;
    int col = 0;

    int result = 0;

    unsigned long bufferLength = 0;

    MYSQL_STMT *sth;

    if (DEBUG) {
        syslog(LOG_AUTHPRIV | LOG_INFO, "insertIntoDB: start");
    }

    /*
     * "date" will usually be NULL. If not NULL it will be in ISO std
     * YYYY-MM-DD HH:mm:SS format.  If we have a date string, modify the 
     * insert statement to accept a bind value for the date -- i.e. replace
     * the "NOW()" in the insert string with a "?"
     */

    if (date != NULL ) {
        tmp = strstr(insertSQL, "NOW())");
        if (tmp != NULL ) {
            tmp = "?)";
            numBindCols++;
        }
    }

    /*
     * setup the statement
     */

    if ((sth = mysql_stmt_init(mysql)) != NULL ) {
        /*
         * setup the prepare
         */
        if (mysql_stmt_prepare(sth, insertSQL, strlen(insertSQL)) == 0) {
            MYSQL_BIND bind[numBindCols];
            memset(bind, 0, sizeof(bind));

            bind[col].buffer_type = MYSQL_TYPE_STRING;
            bind[col].buffer = (void *) PEnv.event;
            bind[col].is_unsigned = 0;
            bind[col].is_null = 0;
            bind[col].buffer_length = 8;
            bufferLength = strlen(PEnv.event);
            bind[col++].length = &bufferLength;
            if (DEBUG) {
                syslog(LOG_AUTHPRIV | LOG_INFO,
                        "insertIntoDB: event=%s/%lu", PEnv.event,
                        bufferLength);
            }

            bind[col].buffer_type = MYSQL_TYPE_STRING;
            bind[col].buffer = (void *) PEnv.rhost;
            bind[col].is_unsigned = 0;
            bind[col].is_null = 0;
            bind[col].buffer_length = 64;
            bufferLength = strlen(PEnv.rhost);
            bind[col++].length = &bufferLength;
            if (DEBUG) {
                syslog(LOG_AUTHPRIV | LOG_INFO,
                        "insertIntoDB: rhost=%s/%lu", PEnv.rhost,
                        bufferLength);
            }

            bind[col].buffer_type = MYSQL_TYPE_STRING;
            bind[col].buffer = (void *) PEnv.user;
            bind[col].is_unsigned = 0;
            bind[col].is_null = 0;
            bind[col].buffer_length = 16;
            bufferLength = strlen(PEnv.user);
            bind[col++].length = &bufferLength;
            if (DEBUG) {
                syslog(LOG_AUTHPRIV | LOG_INFO,
                        "insertIntoDB: user=%s/%lu", PEnv.user,
                        bufferLength);
            }

            bind[col].buffer_type = MYSQL_TYPE_STRING;
            bind[col].buffer = (void *) PEnv.service;
            bind[col].is_unsigned = 0;
            bind[col].is_null = 0;
            bind[col].buffer_length = 64;
            bufferLength = strlen(PEnv.service);
            bind[col++].length = &bufferLength;
            if (DEBUG) {
                syslog(LOG_AUTHPRIV | LOG_INFO,
                        "insertIntoDB: service=%s/%lu",
                        PEnv.service, bufferLength);
            }

            bind[col].buffer_type = MYSQL_TYPE_STRING;
            bind[col].buffer = (void *) source;
            bind[col].is_unsigned = 0;
            bind[col].is_null = 0;
            bind[col].buffer_length = 8;
            bufferLength = strlen(source);
            bind[col++].length = &bufferLength;
            if (DEBUG) {
                syslog(LOG_AUTHPRIV | LOG_INFO,
                        "insertIntoDB: source=%s/%lu", source,
                        bufferLength);
            }

            /*
             * do we have a date string?
             * ... I've not tested this section yet, not sure if the 
             * strtol's will do what I want ...
             */
            if (numBindCols > col) {
                if (DEBUG) {
                    syslog(LOG_AUTHPRIV | LOG_INFO,
                            "insertIntoDB: numBindCols=%d,col=%d",
                            numBindCols, col);
                }

                MYSQL_TIME localDate;
                localDate.year = strtol(date, &datePtr, 10);
                datePtr++;
                localDate.month = strtol(datePtr, &datePtr, 10);
                datePtr++;
                localDate.day = strtol(datePtr, &datePtr, 10);
                datePtr++;
                localDate.hour = strtol(datePtr, &datePtr, 10);
                datePtr++;
                localDate.minute = strtol(datePtr, &datePtr, 10);
                datePtr++;
                localDate.second = strtol(datePtr, &datePtr, 10);

                bind[col].buffer_type = MYSQL_TYPE_DATETIME;
                bind[col].buffer = &localDate;
                bind[col].is_unsigned = 0;
                bind[col].is_null = 0;
                bufferLength = sizeof(localDate);
                bind[col++].length = &bufferLength;
                if (DEBUG) {
                    syslog(LOG_AUTHPRIV | LOG_INFO,
                            "insertIntoDB: date=%s/%lu", date,
                            bufferLength);
                }
            }

            if (mysql_stmt_bind_param(sth, bind) == 0) {
                if (mysql_stmt_execute(sth) != 0) {
                    syslog(LOG_AUTHPRIV | LOG_INFO,
                            "insertIntoDB: MySQL could not execute: %s",
                            mysql_stmt_error(sth));
                    result = __LINE__;
                }
            } else {
                syslog(LOG_AUTHPRIV | LOG_INFO,
                        "insertIntoDB: MySQL could not bind values: %s",
                        mysql_stmt_error(sth));
                result = __LINE__;
            }
        } else {
            syslog(LOG_AUTHPRIV | LOG_INFO,
                    "insertIntoDB: MySQL could not prepare query: %s",
                    mysql_stmt_error(sth));
            result = __LINE__;
        }

        mysql_stmt_free_result(sth);
        mysql_stmt_close(sth);
    } else {
        syslog(LOG_AUTHPRIV | LOG_INFO,
                "insertIntoDB: MySQL could not init statement: %s",
                mysql_stmt_error(sth));
        result = __LINE__;
    }

    if (DEBUG) {
        syslog(LOG_AUTHPRIV | LOG_INFO, "insertIntoDB: end");
    }

    return result;
}

>connect.obj : error LNK2019: unresolved external symbol "__declspec(dllimport) public: __thiscall sql::SQLString::~SQLString(void)" (__imp_??1SQLString@sql@@QAE@XZ) referenced in function _main
1>connect.obj : error LNK2019: unresolved external symbol "__declspec(dllimport) public: __thiscall sql::SQLString::SQLString(class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > const &)" (__imp_??0SQLString@sql@@QAE@ABV?$basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@@Z) referenced in function _main
1>connect.obj : error LNK2019: unresolved external symbol "__declspec(dllimport) public: __thiscall sql::SQLString::SQLString(char const * const)" (__imp_??0SQLString@sql@@QAE@QBD@Z) referenced in function _main
1>connect.obj : error LNK2019: unresolved external symbol "__declspec(dllimport) public: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > const & __thiscall sql::SQLString::asStdString(void)const " (__imp_?asStdString@SQLString@sql@@QBEABV?$basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@XZ) referenced in function "class std::basic_ostream<char,struct std::char_traits<char> > & __cdecl std::operator<<(class std::basic_ostream<char,struct std::char_traits<char> > &,class sql::SQLString const &)" (??6std@@YAAAV?$basic_ostream@DU?$char_traits@D@std@@@0@AAV10@ABVSQLString@sql@@@Z)
1>connect.obj : error LNK2019: unresolved external symbol "__declspec(dllimport) public: class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > const & __thiscall sql::SQLException::getSQLState(void)const " (__imp_?getSQLState@SQLException@sql@@QBEABV?$basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@XZ) referenced in function __catch$_main$0
1>connect.obj : error LNK2019: unresolved external symbol "__declspec(dllimport) public: int __thiscall sql::SQLException::getErrorCode(void)const " (__imp_?getErrorCode@SQLException@sql@@QBEHXZ) referenced in function __catch$_main$0
1>connect.obj : error LNK2019: unresolved external symbol "__declspec(dllimport) class sql::mysql::MySQL_Driver * __cdecl sql::mysql::get_driver_instance(void)" (__imp_?get_driver_instance@mysql@sql@@YAPAVMySQL_Driver@12@XZ) referenced in function _main

UINT blnInsert(SQL& sql)
{
 char* szStr[]={"My Birthday","Walk On Moon?","Some String","April Fools Day"};
 char* szDate[]={"11/15/1952","6/30/1969","1/1/2006","4/1/2006"};
 double dblNum[]={3.14159,1.23456,15.1234,0.54321};
 char  szQuery[100],szString[32],szBuffer[128];       //Let me give you a hint about something.  If you decide
 SQLINTEGER iNts=SQL_NTS;                             //to use raw ODBC as your database access methodology, the
 UINT i,id,iRet=FALSE;                                //hard part is SQLBindParameter() for inserting prepared
 TIMESTAMP_STRUCT ts;                                 //SQL statements, and SQLBindCol() for selecting data.  These
 SQLINTEGER iJnk;                                     //will inevitably take you some time to learn.  I chose an
 SQLHSTMT hStmt;                                      //integer, a double, a data, and a char string so as to get
 double dbl;                                          //you started on the most common data types.

 if(SQLAllocHandle(SQL_HANDLE_STMT,sql.hConn,&hStmt)==SQL_SUCCESS)
 {
    strcpy((char*)szQuery,"INSERT INTO Table1(Id, Float_Point, Date_Field, Text_Field) VALUES(?,?,?,?);");
    printf("                                                         SQLExecute(hStmt)\n");
    printf("iId      Double           Date           String           0=SQL_SUCCESS\n");
    printf("========================================================================\n");
    if(sql.ShowErrors(SQLPrepare(hStmt,(SQLTCHAR*)szQuery,SQL_NTS),SQL_HANDLE_STMT,hStmt)==false)
    {
       sql.ShowErrors(SQLBindParameter(hStmt,1,SQL_PARAM_INPUT,SQL_C_LONG,SQL_INTEGER,0,0,&id,0,&iJnk));
       sql.ShowErrors(SQLBindParameter(hStmt,2,SQL_PARAM_INPUT,SQL_C_DOUBLE,SQL_DOUBLE,0,0,&dbl,0,&iJnk));
       sql.ShowErrors(SQLBindParameter(hStmt,3,SQL_PARAM_INPUT,SQL_C_TYPE_DATE,SQL_TYPE_TIMESTAMP,16,0,&ts,0,&iJnk));
       sql.ShowErrors(SQLBindParameter(hStmt,4,SQL_PARAM_INPUT,SQL_C_TCHAR,SQL_CHAR,31,0,szString,strlen(szString), &iNts));
       for(i=0;i<4;i++)
       {
           id=i+1, dbl=dblNum;
           ts=ParseDate(szDate,"mdy","/");
           strcpy(szString,szStr);
           if(sql.ShowErrors(SQLExecute(hStmt),SQL_HANDLE_STMT,hStmt)==false)
           {
              memset(szBuffer,0,128);
              printf("%-6u%8.2f           %-12.10s  %-20s%6u\n",id,dbl,szDate,szString,SQL_SUCCESS);
           }
       }
       iRet=TRUE;
       printf("\n");
    }
    SQLFreeHandle(SQL_HANDLE_STMT,hStmt);
 }

 return iRet;
}

MYSQL_RES *res;
MYSQL_ROW row;
MYSQL* mysql = XXX();
uint32 ret;
char* sqlQuery = "SELECT MAX(id) FROM mytable";

ret = mysql_real_query(mysql, sqlQuery, (unsigned int)strlen(sqlQuery));
if (ret != 0)
{
  printf("### Error mysql_real_query: '%s'", mysql_error(mysql));
  return;
}

res = mysql_use_result(mysql);
if (res == NULL)
{
  printf("### Error mysql_use_result: '%s'", mysql_error(mysql));
  return;
}
...