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

int main()
{
  char *query = 
"-- BEGIN SAMPLE SQL STATEMENT\n \
SELECT\n \
name,\n \
-- This is a comment\n \
MAX(product_id)\n \
FROM\n \
  product_info\n \
GROUP BY\n \
  product_id;\n\
-- END SAMPLE SQL STATEMENT ";

  MYSQL *mysql;
  MYSQL_ROW row;
  MYSQL_RES *res;

  mysql= mysql_init(NULL);
  mysql_real_connect(mysql, "localhost", "root", "", "test", 3306, NULL, 0);

  printf("Host info: %s\n", mysql_get_server_info(mysql));

  mysql_query(mysql, "DROP TABLE IF EXISTS product_info");
  mysql_query(mysql, "CREATE TABLE product_info (name varchar(20), product_id int)");
  mysql_query(mysql, "INSERT INTO product_info VALUES('foo', 10)");

  if (mysql_query(mysql,  query))
    printf("Error: %s\n", mysql_error(mysql));

  if ((res= mysql_store_result(mysql)))
  {
    int i;
    MYSQL_FIELD *fields= mysql_fetch_fields(res);
    int num_fields= mysql_num_fields(res);
    row= mysql_fetch_row(res);

    for (i=0; i < num_fields; i++)
      printf("%s: %s\n", fields[i].name, row[i]);

    mysql_free_result(res);
  }
 
  mysql_close(mysql);
  return 0;
}