char str[100];
char sql[100];
strcpy(str,"huaguanglu");
// res = mysql_query(&mysql, "insert into mytable( username,age,score,id) values('"+str+"',33,3,18)");
sprintf(sql,"insert into mytable( username,age,score,id) values('%s',33,3,18) ",str);
res=mysql_real_query(&mysql,sql,strlen(sql));
printf("strlen(sql)=%d\n",strlen(str));
if(res)
{
printf("插入数据失败!\n");
}
else
{
//mysql_affected_rows() -- 返回插入或者更新成功的行数。
//printf("插入%d行数据成功!\n",(unsigned long)mysql_affected_rows(&mysql));
printf("成功插入一行数据!\n");
}