#include "my_global.h" // Include this file first to avoid problems

#include "mysql.h" // MySQL Include File

#define SERVER "localhost"

#define USER "username"

#define PASSWORD "password"

#define DATABASE "databasename"


	int main()

	{




		MYSQL *connect; // Create a pointer to the MySQL instance

		connect=mysql_init(NULL); // Initialise the instance


	// This If is irrelevant and you don't need to show
	it.

	// I kept it in for Fault Testing.


		if(!connect) // If instance didn't initialize
		say so and exit with fault.

		{



			fprintf(stderr,"MySQL Initialization Failed");

			return 1;




		}



		// Now we will actually connect to the specific database.

		connect=mysql_real_connect(connect,SERVER,USER,PASSWORD,DATABASE,0,NULL,0);

		// Following if statements are unneeded too, but it's worth it to show on your
		first app,

		// so that if your database is empty or the query didn't return anything it
		will at least

		// let you know that the connection to the mysql server was established.

		if(connect)
		{




			printf("Connection Succeeded\n");




		}


		else

		{




			printf("Connection Failed!\n");




		}


		MYSQL_RES *res_set; // Create a pointer to recieve the return value.

		MYSQL_ROW row; // Assign variable for rows.



		mysql_query(connect,"SELECT * FROM TABLE");
		// Send a query to the database.

		unsigned int i = 0; // Create a counter for the rows

		res_set = mysql_store_result(connect); // Recieve the result and store it
		in res_set

		unsigned int numrows = mysql_num_rows(res_set); // Create the count to print
		all rows

		// This while is to print all rows and not just the first row found,

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

		{




			printf("%s\n",row[i] != NULL ?
			row[i] : "NULL"); // Print
			the row data




		}


			mysql_close(connect); // Close and shutdown

			return 0;






}