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 / raja bhar
#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 ? | 4 Yes | 0 No |
Post New Answer View All Answers
Define the process of error-handling in case of constructor failure?
Explain register storage specifier.
What is the identity function in c++? How is it useful?
Explain linked list using c++ with an example?
What do you mean by inheritance in c++? Explain its types.
What is data abstraction? How is it different from data encapsulation?
Define 'std'.
which of the following is not an secondary constant a) array b) real c) union
Write a code/algo to find the frequency of each element in an array?
Can we use clrscr in c++?
What is the use of string in c++?
what is oops and list its features in c++?
What are pointer-to-members in C++? Give their syntax.
Can I learn c++ without learning c?
What is auto type c++?