#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; }