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
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"))
50 fprintf(stderr
, "%s\n", mysql_error(conn
));
54 result
= mysql_store_result(conn
);
58 fprintf(stderr
, "%s\n", mysql_error(conn
));
62 int num_fields
= mysql_num_fields(result
);
65 printf("\nTable Usine :\n");
66 printf("NU\tNomU\tVille\n");
68 while ((row
= mysql_fetch_row(result
)))
70 for(i
= 0; i
< num_fields
; i
++)
72 printf("%s\t", row
[i
] ? row
[i
] : "NULL");
77 /* close connection */
78 mysql_free_result(res
);