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;
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 it correct...ans for d above progrm....???
Last edited by suraj aryan; 10-31-2011 at 05:44 PM..
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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
2. Programming
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
3. UNIX for Advanced & Expert Users
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
4. UNIX for Dummies Questions & Answers
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
5. Programming
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. Shell Programming and Scripting
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
7. Homework & Coursework Questions
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
8. Solaris
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
9. Shell Programming and Scripting
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
LEARN ABOUT PHP
db2_rollback
DB2_ROLLBACK(3) 1 DB2_ROLLBACK(3)
db2_rollback - Rolls back a transaction
SYNOPSIS
bool db2_rollback (resource $connection)
DESCRIPTION
Rolls back an in-progress transaction on the specified connection resource and begins a new transaction. PHP applications normally default
to AUTOCOMMIT mode, so db2_rollback(3) normally has no effect unless AUTOCOMMIT has been turned off for the connection resource.
PARAMETERS
o $connection
- A valid database connection resource variable as returned from db2_connect(3) or db2_pconnect(3).
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Rolling back a DELETE statement
In the following example, we count the number of rows in a table, turn off AUTOCOMMIT mode on a database connection, delete all of
the rows in the table and return the count of 0 to prove that the rows have been removed. We then issue db2_rollback(3) and return
the updated count of rows in the table to show that the number is the same as before we issued the DELETE statement. The return to
the original state of the table demonstrates that the roll back of the transaction succeeded.
<?php
$conn = db2_connect($database, $user, $password);
if ($conn) {
$stmt = db2_exec($conn, "SELECT count(*) FROM animals");
$res = db2_fetch_array( $stmt );
echo $res[0] . "
";
// Turn AUTOCOMMIT off
db2_autocommit($conn, DB2_AUTOCOMMIT_OFF);
// Delete all rows from ANIMALS
db2_exec($conn, "DELETE FROM animals");
$stmt = db2_exec($conn, "SELECT count(*) FROM animals");
$res = db2_fetch_array( $stmt );
echo $res[0] . "
";
// Roll back the DELETE statement
db2_rollback( $conn );
$stmt = db2_exec( $conn, "SELECT count(*) FROM animals" );
$res = db2_fetch_array( $stmt );
echo $res[0] . "
";
db2_close($conn);
}
?>
The above example will output:
7
0
7
SEE ALSO
db2_autocommit(3), db2_commit(3).
PHP Documentation Group DB2_ROLLBACK(3)