/docs/MyDocs

To get this branch, use:
bzr branch http://darksoft.org/webbzr/docs/MyDocs

« back to all changes in this revision

Viewing changes to Development/languages/C/Samples/mysql/mysql.c

  • Committer: Suren A. Chilingaryan
  • Date: 2009-04-09 03:21:08 UTC
  • Revision ID: csa@dside.dyndns.org-20090409032108-w4edamdh4adrgdu3
import

Show diffs side-by-side

added added

removed removed

Lines of Context:
Development/languages/C/Samples/mysql/mysql.c
 
1
#include <stdio.h>
 
2
#include <mysql/mysql.h>
 
3
 
 
4
MYSQL *dbc;
 
5
MYSQL_RES *res;
 
6
MYSQL_ROW row;
 
7
 
 
8
MYSQL *ec;
 
9
main() {
 
10
 int i;
 
11
 double *r;
 
12
 
 
13
 dbc=mysql_init(NULL);
 
14
 ec=mysql_real_connect(dbc,"192.168.24.111","csa","fts&ukla",NULL,0,NULL,0);
 
15
 if (!ec) {
 
16
    printf("%lu\n",mysql_errno(dbc));
 
17
    puts(mysql_error(dbc));
 
18
    exit(0);
 
19
 }
 
20
 
 
21
 res=mysql_list_dbs(dbc,NULL);
 
22
 row=mysql_fetch_row(res);
 
23
 puts(row[0]);
 
24
 mysql_free_result(res);
 
25
 
 
26
 mysql_query(dbc,"USE hell");
 
27
 
 
28
 mysql_query(dbc,"SELECT data FROM data");
 
29
 res=mysql_store_result(dbc);
 
30
 row=mysql_fetch_row(res);
 
31
 r=(double*)row[0];
 
32
 printf("%lf\n",r[0]);
 
33
 mysql_free_result(res);
 
34
 
 
35
 mysql_close(dbc);
 
36
}