return # of rows updated

[Claus Mygind]

Is it possible to find out how many rows are updated when something like the following code is executed?

update pSum set hours = 8.0 where empno = 623 and detcode = 'Reg'

[mwasif]

You can use MySQL C API function mysql_affected_rows().

[Claus Mygind]

@mwasif
I tried running the example in the MySQL Query Browser but it would not execute

Here is the example your link point to

char *stmt = "UPDATE products SET cost=cost*1.25 WHERE group=10";
mysql_query(&mysql,stmt);
printf("%ld products updated",
       (long) mysql_affected_rows(&mysql));
 

Of course I used my own data for the update command.