#include "stdio.h"
#include "include/mysql.h"

#define def_host_name  "192.168.0.2"
#define def_user_name  "fox"
#define def_password   "fox"
#define def_db_name    "foxdb"

MYSQL  *conn;        /* pointer to connection handler */

int
main (int argc, char *argv[])
{
  conn = mysql_init (NULL);
  if (conn == NULL)
  {
    fprintf (stderr, "mysql_init() failed (probably out of memory)\n");
    exit (1);
  }
  if (mysql_real_connect (
        conn,          /* pointer to connection handler */
        def_host_name, /* host to connect to */
        def_user_name, /* user name */
        def_password,  /* password */
        def_db_name,   /* database to use */
        0,             /* port (use default) */
        NULL,          /* socket (use default) */
        0)             /* flags (none) */
      == NULL)
  {
    fprintf (stderr, "mysql_real_connect() failed:\nError %u (%s)\n",
              mysql_errno (conn), mysql_error (conn));
    exit (1);
  }

	if (mysql_query (conn, "INSERT INTO phones (name,number) VALUES ('Sergio','123456789')") != 0)
	{
	  printf("INSERT statement failed\n");
	}
	else
	{
  	printf ("INSERT statement succeeded: %lu rows affected\n",
        (unsigned long) mysql_affected_rows (conn));
	}

  mysql_close (conn);
  exit (0);
}