Answer» 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..
...i need Explanation for this code....
#include #include
int 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); }We don't do homework...the EXPLAINATION is in the code.... the /* */ are quotes that say /* Connect to database */ well that code is connecting to database???
you should really look elsewhere for a profession
|