Getting the number of rows affected

[Michael Parker]

Howdy,

I'm currently working on a stored procedure that does an:
INSERT ... ON DUPLICATE UPDATE
and I want to then be able to do something else in the procedure depending on if affected rows was 1 or 2. I know that there is a C API function (mysql_affected_rows) to get this information, but how can I get the same info inside the stored procedure?

Update: Nevermind, I obviously missed the whole ROW_COUNT() call....

Thanks
Michael



Edited 1 time(s). Last edit at 03/21/2005 01:24AM by Michael Parker.