如何在linux下利用c连接mysql并执行查询搜索汇总等？

redmarquis

1. 
   
2. #include <stdlib.h>
   
3. #include <stdio.h>
   
4. 
   
5. #include "mysql.h"
   
6. 
   
7. MYSQL my_connection;
   
8. MYSQL_RES *res_ptr;
   
9. MYSQL_ROW sqlrow;
   
10. 
    
11. int main(int argc, char *argv[]) {
    
12.         int res;
    
13.         mysql_init(&my_connection);
    
14.         if (mysql_real_connect(&my_connection,"localhost","rick","bar", "rick", 0, NULL, 0)) {
    
15.                 printf("Connection success\n");
    
16.                 res = mysql_query(&my_connection, "SELECT childno, fname,age FROM children WHERE age > 5");
    
17.                 if (res) {
    
18.                         printf("SELECT error: %s\n", mysql_error(&my_connection));
    
19.                 } else {
    
20.                         res_ptr = mysql_store_result(&my_connection);
    
21.                         if (res_ptr) {
    
22.                                 printf("Retrieved %luows\n",(unsigned long)mysql_num_rows(res_ptr));
    
23.                                 while ((sqlrow = mysql_fetch_row(res_ptr))) {
    
24.                                         printf("Fetched data...\n");
    
25.                                 }
    
26.                                 if (mysql_errno(&my_connection)) {
    
27.                                         fprintf(stderr, "Retrive error: s\n",mysql_error(&my_connection));
    
28.                                 }
    
29.                         }
    
30.                         mysql_free_result(res_ptr);
    
31.                 }
    
32.                 mysql_close(&my_connection);
    
33.         } else {
    
34.                 fprintf(stderr, "Connection failed\n");
    
35.                 if (mysql_errno(&my_connection)) {
    
36.                         fprintf(stderr, "Connection error %d: %s\n",
    
37.                         mysql_errno(&my_connection),mysql_error(&my_connection));
    
38.                 }
    
39.         }
    
40. 
    
41.                 return EXIT_SUCCESS;
    
42. }
    

复制代码

这段代码中的第4行  #include "mysql.h"
编译时提示不存在

然后改为           #include "mysql/mysql.h"
编译时提示如下：

1. 
   
2. /tmp/cccsfBE0.o: In function `main':
   
3. /tmp/cccsfBE0.o(.text+0xf): undefined reference to `mysql_init'
   
4. /tmp/cccsfBE0.o(.text+0x36): undefined reference to `mysql_real_connect'
   
5. /tmp/cccsfBE0.o(.text+0x65): undefined reference to `mysql_query'
   
6. /tmp/cccsfBE0.o(.text+0x83): undefined reference to `mysql_error'
   
7. /tmp/cccsfBE0.o(.text+0xa9): undefined reference to `mysql_store_result'
   
8. /tmp/cccsfBE0.o(.text+0xd1): undefined reference to `mysql_num_rows'
   
9. /tmp/cccsfBE0.o(.text+0xf6): undefined reference to `mysql_fetch_row'
   
10. /tmp/cccsfBE0.o(.text+0x12d): undefined reference to `mysql_errno'
    
11. /tmp/cccsfBE0.o(.text+0x146): undefined reference to `mysql_error'
    
12. /tmp/cccsfBE0.o(.text+0x16d): undefined reference to `mysql_free_result'
    
13. /tmp/cccsfBE0.o(.text+0x17d): undefined reference to `mysql_close'
    
14. /tmp/cccsfBE0.o(.text+0x1a7): undefined reference to `mysql_errno'
    
15. /tmp/cccsfBE0.o(.text+0x1bd): undefined reference to `mysql_error'
    
16. /tmp/cccsfBE0.o(.text+0x1d0): undefined reference to `mysql_errno'
    
17. collect2: ld returned 1 exit status
    

复制代码

请问如何连接？
mysql_real_connect(&my_connection,"localhost","rick","bar", "rick", 0, NULL, 0)中各个参数是什么意思啊？

poweruser

我是菜鸟，关注

redmarquis

感谢关注，继续顶
另外编译的时候加上 -L mysqlclient 也不行

libinary

-lmysqlclient

baidingding

试一下  在后面加上  $(mysql_config --cflags) $(mysql_config --libs)

   ^ _^

i04630123

这些代码比较不错，值得收藏，学习一下！