MySQL Forums
Forum List  »  Stored Procedures

Re: row_count() result of deleting some row from a store procedure
Posted by: charles candy
Date: March 30, 2012 01:55AM

I assume your stored proc code like this

begin
DECLARE row_cnt INT DEFAULT 0;
delete from table_name where date_time <= 'some date_time';
select row_count() into row_cnt;
select row_cnt;

end

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: row_count() result of deleting some row from a store procedure
994
March 30, 2012 01:55AM


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.