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.
Answer Posted / bhagya
/* 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);
}
| Is This Answer Correct ? | 11 Yes | 5 No |
Post New Answer View All Answers
What do you mean by function and operator overloading in c++?
What is helper in c++?
What is the auto keyword good for in c++?
Describe delete operator?
How the virtual functions maintain the call up?
What is difference between array and vector in c++?
Write some differences between an external iterator and an internal iterator?
Explain the difference between static and dynamic binding of functions?
What are guid? Why does com need guids?
What is prototype in c++ with example?
What is virtual base class uses?
Define a conversion constructor?
Explain the use of vtable.
Which is best ide for c++?
How the programmer of a class should decide whether to declare member function or a friend function?