#include "mysql.h"
#include "errmsg.h"

int main( int argc, char** argv ){ 
  MYSQL mysql;
  MYSQL_RES* rs;
  MYSQL_ROW row; 
  MYSQL_FIELD* fields; 
  const char* host = "localhost";
  const char* user = "root";
  const char* passwd = "";
  char* query = "insert into test.affected_test values (1), (2), (3)";
  const char* db = "test";
  int numfields;
  int errcode;
  int i;
  char** group = argv;

  mysql_init( &mysql ); 
  mysql_library_init( argc, argv, group );
  mysql_options( &mysql, MYSQL_READ_DEFAULT_GROUP, "client" );

  printf( "MySQL C Test App...\n" );

  if( ! mysql_real_connect( &mysql, host, user, passwd, db, 3307, "/tmp/mysql5015.sock", 0 ) ){
    printf( "Could not connect to mysql: %s\n", mysql_error( &mysql ) );
    return mysql_errno( &mysql );
  }
     
  //errcode = mysql_real_query( &mysql, query, strlen( query ) );
  errcode = mysql_query( &mysql, query );

  if( errcode ){
    printf( "Query Error: %d\n", mysql_errno( &mysql ) );
  }

  printf( "Affected Rows: %s\n", mysql_affected_rows( &mysql ) );

  mysql_close( &mysql ); 

  return 0;
}