该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
#include
#include
#include
int main()
{
MYSQL *mysql;
int res;
mysql_init(mysql);
if(mysql_real_connect(mysql,"localhost","root","zzlovesm","foo",0,NULL,0))
{
printf("connect success\n");
res = mysql_query(mysql,"insert into children(fname,age) values('Ann',3)");
if(!res)
{
printf("insert %lu rows\n",(unsigned long)mysql_affected_rows(mysql));
}
else
{
fprintf(stderr,"insert error %d : %s",mysql_errno(mysql),mysql_error(mysql));
}
mysql_close(mysql);
}
else
{
fprintf(stderr,"connect failed\n");
if(mysql_errno(mysql))
{
fprintf(stderr,"connection error %d : %s",mysql_errno(mysql),mysql_error(mysql));
}
}
return EXIT_SUCCESS;
}