现在,我们更改代码,所以 'insert' 部分被替换成:
mysql_errno(&my_connection), mysql_error(&my_connection)); } } res = mysql_query(&my_connection, "UPDATE children SET AGE = 4 WHERE fname = 'Ann'"); if (!res) { printf("Updated %lu rows\n", (unsigned long)mysql_affected_rows(&my_connection)); } else { fprintf(stderr, "Update error %d: %s\n",mysql_errno(&my_connection), mysql_error(&my_connection)); }
mysql_error(&my_connection));
} }
res = mysql_query(&my_connection,
"UPDATE children SET AGE = 4
WHERE fname = 'Ann'");
if (!res) { printf("Updated %lu rows\n",
(unsigned long)mysql_affected_rows(&my_connection));
} else { fprintf(stderr, "Update error %d:
%s\n",mysql_errno(&my_connection),
}
2
3
4
5
6
7
8
9
10
11
Andrew
Gavin
Duncan
Emma
Alex
Adrian
Ann
0
if (mysql_real_connect(&my_connection, "localhost", "rick", "bar", "rick", 0, NULL, CLIENT_FOUND_ROWS)) {
"rick", "bar", "rick", 0, NULL, CLIENT_FOUND_ROWS)) {
Copyright @ 2007-2012 敏韬网(敏而好学,文韬武略--MinTao.Net)(学习笔记) Inc All Rights Reserved. 闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)
鄂公网安备 42011102001154号
站长:MinTao ICP备案号:鄂ICP备11006601号-18