3 #include <mysql/mysql.h>
5 //il faut : libmysqlclient-dev
8 // gcc testsqlc.c -o testsqlc -I/usr/include/mysql -lmysqlclient -L/usr/lib64/mysql
20 char *server
= "localhost";
21 char *user
= "fraggle";
23 char *database
= "bdSociete";
25 conn
= mysql_init(NULL
);
27 /* Connect to database */
28 if (!mysql_real_connect(conn
, server
,
29 user
, password
, database
, 0, NULL
, 0)) {
30 fprintf(stderr
, "%s\n", mysql_error(conn
));
35 if (mysql_query(conn
, "show tables")) {
36 fprintf(stderr
, "%s\n", mysql_error(conn
));
40 res
= mysql_use_result(conn
);
42 /* output table name */
43 printf("MySQL Tables in mysql database:\n");
44 while ((row
= mysql_fetch_row(res
)) != NULL
)
45 printf("%s \n", row
[0]);
48 if (mysql_query(conn
, "SELECT * FROM Usine")) {
49 fprintf(stderr
, "%s\n", mysql_error(conn
));
53 result
= mysql_store_result(conn
);
56 fprintf(stderr
, "%s\n", mysql_error(conn
));
60 int num_fields
= mysql_num_fields(result
);
63 printf("\nTable Usine :\n");
64 printf("NU\tNomU\tVille\n");
66 while ((row
= mysql_fetch_row(result
))) {
67 for (i
= 0; i
< num_fields
; i
++) {
68 printf("%s\t", row
[i
] ? row
[i
] : "NULL");
73 /* close connection */
74 mysql_free_result(res
);