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?

Expand|Select|Wrap|Line Numbers

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

Quote:

Originally Posted by mwasif

You can use MySQL C API function mysql_affected_rows().

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

Here is the example your link point to

Expand|Select|Wrap|Line Numbers

 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.

return # of rows updated

re: return # of rows updated

re: return # of rows updated

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about