Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 11445 Views
- Webyog, I also Faced
- E-Mail Answers
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
what are the iterator and generic algorithms.
What do you mean by early binding?
What is pointer to array in c++?
What is new in c++?
Can we use this pointer in a class specific, operator-overloading function for new operator?
Describe exception handling concept with an example?
Do class declarations end with a semicolon?
Explain public, protected, private in c++?
What is meant by a delegate?
Why we use #include conio h in c++?
Explain selection sorting. Also write an example.
Explain queue. How it can be implemented?
Explain what is polymorphism in c++?
What is the use of map in c++?
What is null pointer and void pointer?
