Rows affected in mysql

[pradeepktg]

Hi,

How to find number of rows affected in update statement using mysql (not using php mysql).

Thanks,
Pradeep

[b4web]

Looking at the mysql 5.0 reference manual, under other functions, there is a function called row_count() - returns the number of rows updated, inserted, or deleted by the preceding statement and it sounds like it does the same thing as mysql_affected_rows().