[완료] MySQL C API 중 데이터 가져오는 방법

  if (!mysql_real_connect(mysql,       /* MYSQL structure to use */ 
43                                                         "localhost", /* server hostname or IP address */  
44                                                         "root",      /* mysql user */ 
45                                                         "",          /* password */ 
46                                                         "World",      /* default database to use, NULL for none */ 
47                                                         0,           /* port number, 0 for default */ 
48                                                         NULL,        /* socket file or named pipe name */ 
49                                                         CLIENT_FOUND_ROWS /* connection flags */ )) { 
50                 puts("Connect failed\n"); 
51         } else {                 
52                 if (mysql_query(mysql, "SELECT * FROM City LIMIT 10")) { 
53                         printf("Query failed: %s\n", mysql_error(mysql)); 
54                 } else { 
55                         MYSQL_RES *result = mysql_store_result(mysql); 
56  
57                         if (!result) { 
58                                 printf("Couldn't get results set: %s\n", mysql_error(mysql)); 
59                         } else { 
60                                 MYSQL_ROW row; 
61                                 int i; 
62                                 unsigned int num_fields = mysql_num_fields(result); 
63                                                                  
64                                 while ((row = mysql_fetch_row(result))) { 
65                                         for (i = 0; i < num_fields; i++) { 
66                                                 printf("%s, ", row[i]); 
67                                         } 
68                                         putchar('\n'); 
69                                 } 
70  
71                                 mysql_free_result(result); 
72                         } 
73                 } 
74         } 
75          
76         mysql_close(mysql); 
77  
78         return EXIT_SUCCESS;