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
mysql_list_tables
MYSQL_LIST_TABLES(3) 1 MYSQL_LIST_TABLES(3)
mysql_list_tables - List tables in a MySQL database
SYNOPSIS
Warning
This function was deprecated in PHP 4.3.0, and will be removed in the future, along with the entirety of the original MySQL exten-
sion. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more
information. Alternatives to this function include:
oSQL Query:
SHOW TABLES FROM sometable
resource mysql_list_tables (string $database, [resource $link_identifier = NULL])
DESCRIPTION
Retrieves a list of table names from a MySQL database.
This function is deprecated. It is preferable to use mysql_query(3) to issue an SQL SHOW TABLES [FROM db_name] [LIKE 'pattern'] statement
instead.
o $database
- The name of the database
o $
link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is
assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
is found or established, an E_WARNING level error is generated.
A result pointer resource on success or FALSE on failure.
Use the mysql_tablename(3) function to traverse this result pointer, or any function for result tables, such as mysql_fetch_array(3).
+--------+-----------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+-----------------------------------+
| 4.3.7 | |
| | |
| | This function became deprecated. |
| | |
+--------+-----------------------------------+
Example #1
mysql_list_tables(3) alternative example
<?php
$dbname = 'mysql_dbname';
if (!mysql_connect('mysql_host', 'mysql_user', 'mysql_password')) {
echo 'Could not connect to mysql';
exit;
}
$sql = "SHOW TABLES FROM $dbname";
$result = mysql_query($sql);
if (!$result) {
echo "DB Error, could not list tables
";
echo 'MySQL Error: ' . mysql_error();
exit;
}
while ($row = mysql_fetch_row($result)) {
echo "Table: {$row[0]}
";
}
mysql_free_result($result);
?>
Note
For backward compatibility, the following deprecated alias may be used: mysql_listtables(3)
mysql_list_dbs(3), mysql_tablename(3).
PHP Documentation Group MYSQL_LIST_TABLES(3)