#include <mysql.h>

#include <string.h>

#include <stdio.h>

#include <stdlib.h>

int main(int argc, char **argv)

{

  printf("MySQL client version: %s\n", mysql_get_client_info());

  MYSQL *con = mysql_init(NULL);

  if (con == NULL) {

      fprintf(stderr, "%s\n", mysql_error(con));

      exit(1);

  }

  if (mysql_real_connect(con, "localhost", "root", "", NULL, 0, NULL, 0) == NULL) {

      fprintf(stderr, "%s\n", mysql_error(con));

      mysql_close(con);

      exit(1);

  }

  if (mysql_query(con, "CREATE DATABASE IF NOT EXISTS testdb")) {

      fprintf(stderr, "%s\n", mysql_error(con));

      mysql_close(con);

      exit(1);

  }

  printf("Database created\n");

  if (mysql_query(con, "CREATE TEMPORARY TABLE testdb.my_table(id int, val int)")) {

      fprintf(stderr, "%s\n", mysql_error(con));

      mysql_close(con);

      exit(1);

  }

  printf("Table created\n");

  MYSQL_STMT *stmt;

  stmt = mysql_stmt_init(con);

  if (mysql_stmt_prepare(stmt, "INSERT INTO testdb.my_table(id,val) VALUES( ?, (SELECT ?))", -1) != 0) {

      fprintf(stderr, "Error: %s\n", mysql_stmt_error(stmt));

      return 1;

  }

  MYSQL_BIND bind[2];

  int id[3];

  id[0] = 1;

  id[1] = 2;

  id[2] = 3;

  int val[3];

  val[0] = 10;

  val[1] = 20;

  val[2] = 30;

  char id_ind = STMT_INDICATOR_NONE;

  char val_ind = STMT_INDICATOR_NONE;

  memset(bind, 0, sizeof(bind));

  bind[0].u.indicator = &id_ind;

  bind[0].buffer_type = MYSQL_TYPE_LONG;

  bind[0].buffer = &id;

  bind[1].u.indicator = &val_ind;

  bind[1].buffer_type = MYSQL_TYPE_LONG;

  bind[1].buffer = &val;

  if (mysql_stmt_bind_param(stmt, bind) != 0) {

      fprintf(stderr, "Error: %s\n", mysql_stmt_error(stmt));

      return 1;

  }

  unsigned int numrows = 3;

  mysql_stmt_attr_set(stmt, STMT_ATTR_ARRAY_SIZE, &numrows);

  if (mysql_stmt_execute(stmt) != 0) {

      fprintf(stderr, "Error: %s\n", mysql_stmt_error(stmt));

      mysql_close(con);

      exit(1);

  }

  printf("Results:\n");

  if (mysql_query(con, "SELECT * FROM testdb.my_table")) {

      fprintf(stderr, "%s\n", mysql_error(con));

      mysql_close(con);

      exit(1);

  }

  MYSQL_RES *result = mysql_store_result(con);

  if (result == NULL) {

      printf("No data !?");

      mysql_close(con);

      exit(1);

  }

  int num_fields = mysql_num_fields(result);

  MYSQL_ROW row;

  while ((row = mysql_fetch_row(result))) {

      for (int i = 0; i < num_fields; i++) {

          printf("%s ", row[i] ? row[i] : "NULL");

      }

      printf("\n");

  }

  mysql_free_result(result);

  mysql_close(con);

  exit(0);

}