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

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

2

3

4

5

6

7

8

9

10

11

andrew

gavin

duncan

emma

alex

adrian

ann

ann

ann

ann

10

4

2

0

11

5

3

4

3

4

if (mysql_real_connect(&my_connection, "localhost",                                  "rick", "bar", "rick", 0, null, client_found_rows)) {

如果我們在數據庫中復位數據，然后運行帶有這種修改的程序，則它報告的行數為4。

函數mysql_affected_rows還有最后一個奇怪之處，它發生在從數據庫中刪除數據時。如果使用where子句，則mysql_affected_rows將按預期返回刪除行數。但是，如果沒有where子句，則刪除所有行，報告受影響的行數卻為0。這是因為由于效率原因優化刪除整個表。這種行為不受client_found_rows選項標志的影響。