在MySQL数据库中使用C执行SQL语句

int mysql_query(MYSQL *connection, const char *query)

my_ulonglong mysql_affected_rows(MYSQL *connection);

#include 
#include #include 
"mysql.h"int main(int argc, char *argv[]) 
{MYSQL my_connection;
int res;mysql_init(&my_connection);
 if (mysql_real_connect(&my_connection, "localhost", 
 "rick", "bar", "rick", 0, NULL, 0)) {   
 printf("Connection success\n");  
 res = mysql_query(&my_connection,      
    "INSERT INTO children(fname,age),   
       VALUES('Ann',3)");   if (!res) 
{              printf("Inserted %lu rows\n",  
             (unsigned long)mysql_affected_rows(&my_connection));
            } else {  
            fprintf(stderr, "Insert error %d: s\n",mysql_errno , 
             (&my_connection),
  mysql_error(&my_connection));             }  
  mysql_close(&my_connection);         } else
 {           fprintf(stderr, "Connection failed\n");  
          if (mysql_errno(&my_connection)) 
{fprintf(stderr, "Connection error 
%d: %s\n",mysql_errno(&my_connection),mysql_error&my_connection));
            }         }        
 return EXIT_SUCCESS;    }