C/C++ program that connects to a MySQLserver

Thread Tools Search this Thread
Homework and Emergencies Homework & Coursework Questions C/C++ program that connects to a MySQLserver
# 1  
Old 08-23-2011
C/C++ program that connects to a MySQLserver

Hi Programming Geeks,

I got an interesting C++ and MySQL problem to solve.
I was unable to do this as I am not much confident on MySQL DB.
Please have a go at it if possible.

Write a C/C++ program that connects to a MySQLserver 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.

What resources did you use to do research for this project?

What development tools did you do use to complete the project?

How did you test & debug the project?

Why have you chosen to use the programming language used in the project?

Appreciate your response.
# 2  
Old 08-23-2011
# 3  
Old 08-23-2011
Originally Posted by pludi
Dear Pludi,

This is not a homework. This program is needed for a development work in My Company.

They need me to implement a product in which this part is needed..I have done all the UNIX/SOLARIS/ORACLE related coding but this is the last portion which I am unable to do as I am very week in C,C++ and don't have much knowledge on MySQL.
# 4  
Old 08-23-2011
Given the way the questions are phrased, I assume it's either homework, or an interview question. And cheating on both is strongly discouraged here.
# 5  
Old 10-31-2011
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.

dear budy,
i m jobless nd cmpy given me opputunty to solve dis ques if i solve it then they give me the job which i really need this time....plz give me atleast some hint so that i can do it my self only......

---------- Post updated at 02:17 AM ---------- Previous update was at 01:58 AM ----------

#include <mysql.h>
#include <stdio.h>
main() {
MYSQL *conn;
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));
/* send SQL query */
if (mysql_query(conn, "show tables")) {
fprintf(stderr, "%s\n", mysql_error(conn));
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 */
is it correct...ans for d above progrm....???

Last edited by suraj aryan; 10-31-2011 at 05:44 PM..
# 6  
Old 10-31-2011
new question = new thread!
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perl program get a response before the program quits

I created a program, so a kid can practice there math on it. It dispenses varies math problems and the kid must input an answer. I also want it to grade the work they have done, but I can't find the best place for it to print out the grade. I have: if ( $response =~ m/^/ ) { $user_wants_to_quit... (1 Reply)
Discussion started by: germany1517
1 Replies

2. Solaris

Solaris ftp connects out svc disabled.

Hi, Running ftp online 2:53:02 svc:/network/ftp:default If I disable ftp disabled 2:54:00 svc:/network/ftp:default I can still SEND ftp files out. I cannot connect to this server via FTP, but why can I still connect to other ftp servers and send files? Cheers. (5 Replies)
Discussion started by: RedWizard75
5 Replies

3. Homework & Coursework Questions

Calling compiled C program with Perl program

Long story short: I'm working inside of a Unix SSH under a bash shell. I have to code a C program that generates a random number. Then I have to call the compiled C program with a Perl program to run the C program 20 times and put all the generated random #s into a text file, then print that text... (1 Reply)
Discussion started by: jdkirby
1 Replies

4. Shell Programming and Scripting

In real time - what user connects or disconnect

Write a tool that will be displayed in real time, what user connects or disconnects from a system that uses this tool :)) Maybe anyone can help me? (2 Replies)
Discussion started by: titasas
2 Replies

5. Programming

Python program faster than C++ program.

I wrote a simple program that generates a random word 10,000,000 times. I wrote it in python, then in C++ and compared the two completion times. The python script was faster! Is that normal? Why would the python script be faster? I was under the impression that C++ was faster. What are some of... (2 Replies)
Discussion started by: cbreiny
2 Replies

6. UNIX for Dummies Questions & Answers

Script to open program and send/execute command in program

Hi, i want to write a script that executes a program (exec?) . this program then requires a filename as input. how do i give it this input in the script so the program will be complete run and close by the script. e.g. exec prog.exe program then asks for filename "enter filename:"... (1 Reply)
Discussion started by: tuathan
1 Replies

7. UNIX for Advanced & Expert Users

how does editplus connects to unix server

hi all i am working on a monitoring script for my server... i am able to monitor all the explicit sessions ... the problem arises when some one is using editplus to modify a file in the server .. the unix server is not showing the edit plus access as a session ... how to monitor the actions... (3 Replies)
Discussion started by: sais
3 Replies

8. Programming

A program to trace execution of another program

Hi, I wanted to know if i can write a program using switches and signals, etc to trace execution of other unix program which calls c program internally. If yes how? If not with signals and switches then are there any other methods apart from debugging with gdb/dbx. (3 Replies)
Discussion started by: jiten_hegde
3 Replies

9. UNIX for Dummies Questions & Answers

How to write to stdin of another program (program A -> [stdin]program B)

Hi, Program A: uses pipe() I am able to read the stdout of PROGAM B (stdout got through system() command) into PROGRAM A using: * child -> dup2(fd, STDOUT_FILENO); -> execl("/path/PROGRAM B", "PROGRAM B", NULL); * parent -> char line; -> read(fd, line, 100); Question: ---------... (3 Replies)
Discussion started by: vvaidyan
3 Replies
Login or Register to Ask a Question