setting value of row_count()

i have a stored procedure consisting of several delete statements and i
want to be able to return the "Query OK, 0 rows affected" such that the
total number of rows deleted are summed up rather than returning the
number of affected rows of the last statement.

the number of rows deleted can be obtained through the ROW_COUNT() and i
can add it up. but how do i set the value of the "Query OK, XXX rows
affected"?

- wrote:
 > the number of rows deleted can be obtained through the ROW_COUNT() and i
 > can add it up. but how do i set the value of the "Query OK, XXX rows
 > affected"?

I think you need to add up the row count and return it as an OUT
parameter of the procedure.

Regards,
Bill K.<!-- ~MESSAGE_AFTER~ -->