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
If you hear the cpu fan is running and the monitor power is still on, but you did not see anything show up in the monitor screen. What would you do to find out what is going wrong?
Differentiate between an array and a list?
How can I learn dev c++ programming?
Why are pointers used?
what are the iterator and generic algorithms.
What is pure virtual function? Or what is abstract class?
In which header file does one find isalpha() a) conio.h b) stdio.h c) ctype.h
By using c++ with an example describe linked list?
What are references in c++?
What it is and how it might be called (2 methods).
Describe delete operator?
How would you use the functions sin(), pow(), sqrt()?
What is stack unwinding?
What is static function? Explain with an example
What is private inheritance?