Homework & Coursework Questions

Hi Programming Geeks,

I got an interesting C++ and MySQL problem to solve.
I was unable to do this as I am not much confident on MySQL DB.
Please have a go at it if possible.

Write a C/C++ program that connects to a MySQLserver and checks if
the InnoDB plug-in is installed on it. If so, your program should
print the total number of disk writes by MySQL.

What resources did you use to do research for this project?

What development tools did you do use to complete the project?

How did you test & debug the project?

Why have you chosen to use the programming language used in the project?

Appreciate your response.

Homework?

Dear Pludi,

This is not a homework. This program is needed for a development work in My Company.

They need me to implement a product in which this part is needed..I have done all the UNIX/SOLARIS/ORACLE related coding but this is the last portion which I am unable to do as I am very week in C,C++ and don't have much knowledge on MySQL.

Given the way the questions are phrased, I assume it's either homework, or an interview question. And cheating on both is strongly discouraged here.

Write a C/C++ program that connects to a MySQL server and checks if the InnoDB plug-in is installed on it. If so, your program should print the total number of disk writes by MySQL.



dear budy,
i m jobless nd cmpy given me opputunty to solve dis ques if i solve it then they give me the job which i really need this time....plz give me atleast some hint so that i can do it my self only......

---------- Post updated at 02:17 AM ---------- Previous update was at 01:58 AM ----------

#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);
}
is it correct...ans for d above progrm....???

new question = new thread!