MySQL Forums
Forum List  »  Stored Procedures

Getting the number of rows affected
Posted by: Michael Parker
Date: March 20, 2005 10:05PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Getting the number of rows affected
14862
March 20, 2005 10:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.