insert1.c

#include <stdlib.h>
#include <stdio.h>
#include "mysql.h"

int main(int argc, char *argv[])
{
    MYSQL my_connection;
    int res;

    mysql_init(&my_connection);
    if (mysql_real_connect(&my_connection, "192.168.20.80",
            "root", "root", "words", 0, NULL, 0)) {
        printf("Connection success\n");

        res = mysql_query(&my_connection, "insert into c_test(id, content) values ('', 'hello')");
        if (!res) {
            printf("Inserted %lu rows\n", 
                (unsigned long) mysql_affected_rows(&my_connection));
        } else {
            fprintf(stderr, "Insert error %d: %s\n",
                mysql_errno(&my_connection), mysql_error(&my_connection));
        }
        mysql_close(&my_connection);
    } else {
        fprintf(stderr, "Connection failed\n");
        if (mysql_errno(&my_connection)) {
            fprintf(stderr, "Connection error %d: %s\n",
                mysql_errno(&my_connection), mysql_error(&my_connection));
        }
    }
    return EXIT_SUCCESS;
}