showdb_test.c
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:2k
- /* Copyright (C) 2000 MySQL AB
- This program is free software; you can redistribute it and/or modify
- it under the terms of the GNU General Public License as published by
- the Free Software Foundation; either version 2 of the License, or
- (at your option) any later version.
- This program is distributed in the hope that it will be useful,
- but WITHOUT ANY WARRANTY; without even the implied warranty of
- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
- GNU General Public License for more details.
- You should have received a copy of the GNU General Public License
- along with this program; if not, write to the Free Software
- Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */
- #ifdef __WIN__
- #include <windows.h>
- #endif
- #include <stdio.h>
- #include <stdlib.h>
- #include "mysql.h"
- #define SELECT_QUERY "select name from test where num = %d"
- int main(int argc, char **argv)
- {
- int count, num;
- MYSQL mysql,*sock;
- MYSQL_RES *res;
- char qbuf[160];
- if (argc != 3)
- {
- fprintf(stderr,"usage : select_test <dbname> <num>nn");
- exit(1);
- }
- mysql_init(&mysql);
- if (!(sock = mysql_real_connect(&mysql,NULL,0,0,argv[1],0,NULL,0)))
- {
- fprintf(stderr,"Couldn't connect to engine!n%snn",mysql_error(&mysql));
- perror("");
- exit(1);
- }
- count = 0;
- num = atoi(argv[2]);
- while (count < num)
- {
- sprintf(qbuf,SELECT_QUERY,count);
- if(!(res=mysql_list_dbs(sock,NULL)))
- {
- fprintf(stderr,"Query failed (%s)n",mysql_error(sock));
- exit(1);
- }
- printf("number of fields: %dn",mysql_num_rows(res));
- mysql_free_result(res);
- count++;
- }
- mysql_close(sock);
- exit(0);
- return 0; /* Keep some compilers happy */
- }