not showing total number of records for two update queries

Question

0.00/5 (No votes)

See more:

i am trying to use two update statements in mysql as stored procedure
it only shows the number of affected rows for last update query
i need it combined

SQL

DELIMITER //
 CREATE PROCEDURE SP_Lock_update(IN locked int(1),IN user_id int)
    BEGIN
        update user_register , comments,articles
set
user_register.locked=locked,
comments.locked=locked,
articles.locked=locked
where
user_register.user_id=user_id
and
comments.user_id=user_id
and
articles.user_id=user_id;

update comments
set
locked=locked
where article_id in (select article_id from articles where user_id=user_id);
    END //
 DELIMITER ;

Posted 2-Dec-12 7:29am

mohanrajkiller

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tim Corey · Answer 1 · 2012-12-02T16:32:00

What you want to do is use the @@ROWCOUNT variable after each statement and put that number into a variable. Then output that variable from your stored procedure. This Stack Overflow question will help out a bit:

http://stackoverflow.com/questions/1103260/return-number-of-rows-affected-by-update-statements[^]

Edit
Sorry, I misread the question as being SQL. For MySQL, the concept is the same, but you use the ROW_COUNT() construct instead of @@ROWCOUNT (at least for modification statements like you are doing). If you wanted to capture rows from a SELECT, use the FOUND_ROWS() construct.

not showing total number of records for two update queries

1 solution

Solution 1

Add your solution here

Preview 0

not showing total number of records for two update queries

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us