#define HOSTNAME ""
#define USERNAME ""
#define PASSWORD ""
#define DATABASE ""

#include "mysql.h"

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

int main(int argc, char **argv)
{
    char sql[100];

    MYSQL mysql;

    sprintf(sql, "DELETE FROM test");

    mysql_init(& mysql);

    mysql_real_connect(& mysql, HOSTNAME, USERNAME, PASSWORD, DATABASE, 0, NULL, CLIENT_LOCAL_FILES);

    mysql_select_db(& mysql,"test");
    mysql_real_query(& mysql, sql, strlen(sql));
    mysql_close(& mysql);
    return 0;
}