Skip navigation links

MySQL Newsletter - Subscribe Today!

The world's most popular open source database

MySQL 5.1: mysql/src/5.1-dbg/tests/list_test.c File Reference

mysql/src/5.1-dbg/tests/list_test.c File Reference

#include <stdio.h>
#include <stdlib.h>
#include "mysql.h"

Include dependency graph for list_test.c:

Go to the source code of this file.


Defines

#define SELECT_QUERY   "select name from test where num = %d"

Functions

int main (int argc, char **argv)

Define Documentation

#define SELECT_QUERY   "select name from test where num = %d"

Definition at line 24 of file list_test.c.

Referenced by main().

Function Documentation

int main ( int  argc,
char **  argv 
)

Definition at line 27 of file list_test.c.

References count, exit, mysql, mysql_close(), mysql_error(), mysql_free_result(), mysql_list_dbs(), mysql_list_tables(), mysql_select_db(), NULL, perror(), st_mysql::reconnect, and sock.

00028 {
00029   int   count, num;
00030   MYSQL mysql,*sock;
00031   MYSQL_RES *res;
00032   char  qbuf[160];
00033 
00034   if (argc != 2)
00035   {
00036     fprintf(stderr,"usage : select_test <dbname>\n\n");
00037     exit(1);
00038   }
00039 
00040   if (!(sock = mysql_connect(&mysql,NULL,0,0)))
00041   {
00042     fprintf(stderr,"Couldn't connect to engine!\n%s\n\n",mysql_error(&mysql));
00043     perror("");
00044     exit(1);
00045   }
00046   mysql.reconnect= 1;
00047 
00048   if (mysql_select_db(sock,argv[1]) < 0)
00049   {
00050     fprintf(stderr,"Couldn't select database %s!\n%s\n",argv[1],
00051             mysql_error(sock));
00052     exit(1);
00053   }
00054 
00055   if (!(res=mysql_list_dbs(sock,NULL)))
00056   {
00057     fprintf(stderr,"Couldn't list dbs!\n%s\n",mysql_error(sock));
00058     exit(1);
00059   }
00060   mysql_free_result(res);
00061   if (!(res=mysql_list_tables(sock,NULL)))
00062   {
00063     fprintf(stderr,"Couldn't list tables!\n%s\n",mysql_error(sock));
00064     exit(1);
00065   }
00066   mysql_free_result(res);
00067 
00068   mysql_close(sock);
00069   exit(0);
00070   return 0;
00071 }

Here is the call graph for this function:

Generated on Sat Sep 9 19:32:46 2006 for MySQL 5.1 by  doxygen 1.4.7