Hi,
I'm writing a C++ script and part of it is to connect to an SQL Server. C++ is new to me so I'm still working my way around.
Any help would be greatly appreciated.

Many Thanks

Simple C program that connects to MySQL Database server

#include <mysql.h>

#include <stdio.h>

main() {

   MYSQL *conn;
   MYSQL_RES *res;

   MYSQL_ROW row;

   char *server = "localhost";

   char *user = "root";

   char *password = "PASSWORD"; /* set me first */

   char *database = "mysql";


   conn = mysql_init(NULL);


   /* Connect to database */    
   if (!mysql_real_connect(conn, server,

         user, password, database, 0, NULL, 0)) {

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

      exit(1);

   }

   /* send SQL query */
   if (mysql_query(conn, "show tables")) {

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

      exit(1);
   }


   res = mysql_use_result(conn);


   /* output table name */
   printf("MySQL Tables in mysql database:\n");

   while ((row = mysql_fetch_row(res)) != NULL)

      printf("%s \n", row[0]);


   /* close connection */
   mysql_free_result(res);

   mysql_close(conn);
}

Edited 3 Years Ago by pyTony: fixed formatting

This article has been dead for over six months. Start a new discussion instead.